Paramater Query that brings up a lookup table

[landerson]

Hello, is there any way I can have my single-parameter query bring up a lookup list of options from a table field rather than relying on the user to correctly type in the criteria? Then when this query runs I will know the user is picking one of the correct options from the lookup list.

Thanks.

 

[pbaldy]

No; the parameter box when using [Enter criteria] is very limited. You'll need to have them enter/select the criteria from a form control, and have the query look to that control for the criteria.

 

[landerson]

Great! Thank you for your answer.