Web Development

Ask something
Question Locked

MS Access- Using Multiple Parameters in a Contol Tag for Queries

0 helpful
4 replies

by harry.cheung

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I would like some help please.

I am using a form control's tag to pass a parameter to a query which is fine.
e.g. me.control.tag = "1". One of my field criteria in a query is [Forms]![frmForm]![control].[Tag]. This will show relevant records.

When I try to change it to do multiple paramters in the control tag the query doesn't seem to recognise this.
e.g. me.control.tag = "1 Or 2" will show no records even though it would for the above control tag value.

Any ideas on how to make it do what I want?

Thanks,
Harry

4 replies

by harry.cheung

Hi, thanks for the reply John.

I'm not quite sure how to do this. Am I right in saying that the tag is stored as a string? If so how would I store:
me.control.tag = "1" or me.control.tag = "2"
in the tag?

Ultimately I am trying to pass the parameter so to the query (design view) it looks like this:
1 Or 2

by john.a.wills

I do not know much about tags, but they do appear to be stored as strings. One addresses them pretty much as one addresses any form or control property in VBA.

This discussion is closed to new replies.