Use combo in paramater query

[Frank72]

Hows it going

I'm trying to use a combo box to act as a criteria in a query. I have done it before but changed it and now cannot get it to work again. I know is got to do with indexes but have kind of forgotten exactly how to do it.

Thanks alot

Frank

 

[jebry]

Hi Frank!

All you should need to do is type the following in the criteria line in the query builder:

Forms!YourForm!YourComboBox

This should work unless there is more to the story.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Frank72]

Hi Jeff

Long time!
still at this! yeah thats what i thought , no need to complicate matters. i think i'm confusing it with other situations.I'll give that a go thanks alot

Frank