Query Criteria

[ViRi]

I have a query based on a table that contains a field called Client

On the criteria line on the query I've got [Enter Client] so that the query can run based on the client the user enters on the dialog window input box. Is it possible to show a list of clients currently on the databse on this dialog so that the user can choose instead of having rely on the users' memory.

ViRi

 

[Rickster57]

clients

Use a form with a combo box of your clients and use this field in the criteria expression of your query....forms![myform].[client]