Query with parameters

[Sarah at DaVita]

I want to write a make table query were the user choose the parameter from a
list. I do not want to use &*[ enter class name]&* because if they do not
get the class name exact it will return too many rows. How can I do this? I
can not seem to figure it out.

 

[Wayne-I-M]

1 method would be to create a small popup form with a combo or list and use
this to pass the filter to the query

 

[Danny Seager]

Create and save your form with the controls on it...

Then use the criteria

forms!YourFormName!YourControlName

 

[Sarah at DaVita]

Thank you!!!!!!!!!!!!!!!!!

Create and save your form with the controls on it...

Then use the criteria

forms!YourFormName!YourControlName

I want to write a make table query were the user choose the parameter from a
list. I do not want to use &*[ enter class name]&* because if they do not
get the class name exact it will return too many rows. How can I do this? I
can not seem to figure it out.