Specifiy query criteria using a form

[mark-charlwood]

i want to create a form which will allow me to type in search criteria for my query!

i.e. i have a list of customers and i can query them by entering criteria like (a* or s* or whatever) in the query in design view

but i want to be able to specify this criteria from a form

i know this can be done but i dont know how

please help ASAP!

thanks

 

[Susilowati]

In order to do this, you have to create a filter form which should execute on your query. The filter form should be unbounded. Now, in the query, instead of putting like (a* or s* or whatever) in your criteria, put
"Like [Forms]![FrmCriteria]![CustomerControl]".
Try that for only one control at a time. Let me know if you still have more problems.
cheers SS

 

[zzz]

I sent you an example