Parameter query

message from Ray on 9 May 2004
Is there a way of creating a pull down menu of specific
paramaters (ie names)that are already in the adta base so
that you do not have to type in the query string you want
all the time?

thanks in advance

ray
 
Brendan Reynolds replied to Ray on 10 May 2004
Not using the built-in parameter dialog box, but you can do it with a custom
SELECT * FROM SomeTable WHERE SomeTable = Forms!frmTest!cboTest

The form must be open when the query is run.
 
Ray replied to Brendan Reynolds on 10 May 2004
CAn you send me a small example?
do it with a custom
MDB contains a form,
box, "cboTest" ...
cboTest
it impossible for
mail replies to
claiming to be
signed by me with a
be deleted without
posted to the
mail, you'll find
want
 

Archived message: Parameter query (Microsoft Access)