MS Access- Using Multiple Parameters in a Contol Tag for Queries - TechRepublic
Question
August 17, 2007 at 05:48 AM
harry.cheung

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

by harry.cheung . Updated 18 years, 10 months ago

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

This discussion is locked

All Comments