Queries with selection from a FormField

  • Thread starter Thread starter John Bruen
  • Start date Start date
J

John Bruen

I have a query where the criteria is coming from a form,
ie: FORMS!FRMSELECT!MySelect. If I put a single value in
the field - "A" (with out quotes), it works fine. When I
put ="A" or "B" in the field, no data is returned from the
query. Is there any way to put multiple values in the
criteria coming from a form field?
 
I have a query where the criteria is coming from a form,
ie: FORMS!FRMSELECT!MySelect. If I put a single value in
the field - "A" (with out quotes), it works fine. When I
put ="A" or "B" in the field, no data is returned from the
query. Is there any way to put multiple values in the
criteria coming from a form field?
Click to expand...

Not easily. A parameter in a Query can contain only values to be
searched, and cannot contain operators such as OR.

What you'll need to do is write VBA code to poll through the controls
on FRMSELECT and build up a valid SQL string. If you're using free
textboxes and letting the user type in any arbitrary SQL code, you
need to be certain that the users have a solid understanding of SQL
syntax!
 
Back
Top