Parameter Query - Combo Box?

[Meijhana]

Is it possible, when using a parameter query to make the message box that appears asking for the parameters be a combo box to reduce the chances of the user misspelling something?

Thanks

 

[pbaldy]

No; you'd have to create a form and point the criteria there instead of [Enter blah].

 

[Meijhana]

I tried that initially, but then I could not edit any of the data in the resulting query data sheet

Any quggestions on how to make it so that it will still let me edit the data?

I wanted combo boxes for Doc # and Department. Those were each based off a previously set-up query to show the Distinct results.

Thanks

 

[pbaldy]

Where the criteria comes from would have no effect on whether you could edit the data, so I'd just change your existing query to use a form. Here's info on what makes a query read only:

http://allenbrowne.com/ser-61.html