parameter drop down?

[Weresmytriple]

hi all,

i have created a query with the parameter for the Domain field. however on the form the user enters this information via a drop down menu. i was just wondering could the parameter box be set to a drop down box as well to save the user entering in the full Domain field name?

thanks for any help

michael

 

[pbaldy]

If you're talking about a bracketed parameter, no. Why not just have the query point to the form (or a form)?

 

[David R]

Why is your user running the query directly, rather than through the form? Or is this for your testing?

 

[Weresmytriple]

this is just for my testing however the user will be running it from a form

 

[David R]

Okay good.

Sad to say, I don't think there's a way to tell Access to use a dropdown for an actual [parameter], as that's a very low-level Access value.

What I usually do is run it from the form, even in testing. If the form controls the parameter value, you can make that field a dropdown.

 

[Weresmytriple]

no i didnt think it was possible just wanted to double check

thanks for the help tho

 

[namliam]

Like david said, it IS possible... just not possible in a parameter only setting....

Have a looksee at this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=1300908#post1300908

The link and explenation I gave there.