parameter

[freelancer]

Bit of a long shot, this. Is there any way that a parameter query can have a
drop down list of options? The DB I am building has the option of searching
for a record via the ‘client’ name field. I might enter a record with a
client name of ‘x’ but a colleague of mine may not know that this client has
been added and therefore would not know to search for the name. If this is
not possible what would be a credible alternative?

Any responses will be greatly appreciated

 

[Allen Browne]

No. The parameter dialog does not support combos.

Of course, you could create a form with a combo on it, and then refer to it
in your query. Something like:
[Forms].[Form1].[Combo1]