Parameter Help

[Eric Starn]

I am wondering if it is possible to run a parameter query so that when the
dialog box opens it will also have a dropdown list so the user can select the
parameter from it.
If so how would you accomplish this.

Eric

 

[Dale_Fye via AccessMonster.com]

Nope,

But you could create a function which opens a form (acDialog) which contains
the dropdown list and buttons (OK Cancel). These buttons would hide the form,
allowing the code in the funtion to capture the value from the dropdown list,
close the form, and return the selected value it back to the query.

HTH
Dale