Parameter value box as Combo box

[Randhir_k]

Hi all experts

I have a query titled RT Bill. The query returns quantity of work done for particular Client in particular period.
When I execute the query an Enter Parameter Value dialog box is displayed with the caption "Client Name". One of the 50 possible values from the Client field needs to be entered manually.
Is there a way to make the Enter parameter value box to display as combo box with a drop-down menu of all client names from Client Name Field ?

Thank you very much in advance

 

[isladogs]

Not using a parameter query.
Use a combo box on a form. In the after update event for the combo, run SQL that uses that value as your 'parameter'