Is there a way to set up a query so that a drop-down box will open for you to put a filter on? I see in my reference books that it can be done is Forms, but I haven’t been able to make it work for a query.
Thanks!
StG
I think you have to do that in a form, then attach the query to that form.
You can create a “parameter query” that will give you a popup box to fill in with data, but I don’t know of any way to make a query use a drop-down.
I’d tell you more, but I know bupkus about forms.
Good luck!
Could you be a bit more specific about what you’re trying to do? Also, which version of Access?
Devorin - I’ll check when I get back to work about the version. What I want is to be able to use a column from a table that is part of the query. So if there’s a list of accounts in a table, and I want to use that as part of a query, instead of having to go into the design mode and manually changing the value in the criteria area, it would just allow a value to be selected from the list. I want to make it as easy for the user to work, especially without giving them the opportunity to screw up the query.
Thanks for all the help, both of you.
StG
You’ll need to do it in a form. But judging from your description of what you are trying to do… a form makes a lot more sense.
Forms are more user friendly and give you more control. Even a dumbed down form is far preferable. I’d never go back - not if it’s for an end user.
Anomolous Reading - I thought a form would simplfy data entry. I didn’t know it could give a data range, or the info from a query.
I’m all self-taught and there are obviously gaps in my knowledge. I’ll have to read my books a bit more. Thanks for the help.
StG
Can the form be somehow imbedded in the Query so you can get the data out of it?
StG
Huh, what do you know…something I can help with.
What you want to do is make two things…a query and a form. The form will be very basic. Pretty much just one field. Create a drop down box in the form, then have it look up the values from the table and field where you have those accounts listed. Then you make a query that has the data you want. For the parameter of the query in that account field, point to the same field in the form you just made. …Hell, screw it I’m terrible at explaining stuff like this. Is your email listed? It would be faster for me to make a word document with screen captures explaining. It’s not difficult…just difficult for (me) to explain with just typing.
This free online book from Microsoft has all kinds of examples, hopefully you’ll find something you can use… link