Seaching problem

[Josh]

Is there a way to use a drop down menu in a query so that
my users can search for records containing one of the
accepted codes without them having to memorize the list?

 

[chas]

Hi Josh,

pretty sure you can't do this in a query, but you could
give your users a combobox on a Form to do this. The
technique is known as Query By Form and is detailed in the
following Microsoft article:

http://support.microsoft.com/?id=209645
(ACC2000: How to Use the Query by Form (QBF) Technique)

hth

chas