Drop-down menu Query?

[chris990]

Hey guys,
Is it possible to create a drop-down menu Query, as opposed to the basic Parameter Query where the condition is typed in a dialog box? Just thinking it would be easier for the user in that it would eliminate mistakes due to spelling errors. Would it be possible?

 

[ScottGem]

Hey guys,
Is it possible to create a drop-down menu Query, as opposed to the basic Parameter Query where the condition is typed in a dialog box? Just thinking it would be easier for the user in that it would eliminate mistakes due to spelling errors. Would it be possible?

Of course it would, which is why I very rarely use parameter queries. Instead I create a form to supply the values. Using an unbound form and controls I will have the user enter criteria. I then use:

=Forms!formname!controlname

in the criteria for the query. This syntax allows you to reference a value in a control on an open form.

 

[chris990]

Sweet, works like a charm!

One question though, is an unbound form created by choosing New Form in design mode or is there another way to do it? I ask because I created a form without selecting a data-source, but still at the bottom there is a record-scroller which I don't want.

 

[ScottGem]

An unbound form is one without a RecordSource. Recordselectors and Navigation buttons are turned on by default whether the form is bound or no. You can turn them off under the Format properties for the form.

 

[chris990]

Excellent, thanks.