Query which gets the search parameter from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which gets its search parameter from combo box on a form. I
want to have an the Option in the combo box on the form (ALL) which will
allow me the option of retrieving all the records for the query.

I have got the query to work using the LIKE "*" syntax but cannot see how to
set this up as a menu option in the form.

Hope someone can help. As always many thanks.

Peter
 
Pter,

Use a criterion like:

Like Forms![FormName]![ComboName]

in your query. Then, add a "*" (without the quotes) to the combo's
rowsource. This way, when the user selects the *, the query will return
all the records.

HTH,
Nikos
 
Thanks Nikos.

Peter

Nikos Yannacopoulos said:
Pter,

Use a criterion like:

Like Forms![FormName]![ComboName]

in your query. Then, add a "*" (without the quotes) to the combo's
rowsource. This way, when the user selects the *, the query will return
all the records.

HTH,
Nikos
I have a query which gets its search parameter from combo box on a form. I
want to have an the Option in the combo box on the form (ALL) which will
allow me the option of retrieving all the records for the query.

I have got the query to work using the LIKE "*" syntax but cannot see how to
set this up as a menu option in the form.

Hope someone can help. As always many thanks.

Peter
Click to expand...
Click to expand...
 
Back
Top