How-to create dynamic where clause

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a query and I want the user to be able to select
from a list box to limit what's returned. From the
selections made, I create a string in a text box in order
to pass to the query

I put "IN ([FORMS]![frmReports]![txtCriteria])" in the
where clause. This works if I select 1 item from the
list box. If I select more than 1, I get an empty
resultset.

Any help would be greatly appreciated.

Thanks,
Tim
 
It has to do with the way List Boxes pass data back to your queries. I
normally use VBA code to process the data passed from list boxes and build
my recordsets.

Regards,

Sal Rosario
Database Cosultant in NJ
www.salrosario.com
 
Back
Top