multiple choice

[ACCESS NEWB]

I have a query which check assignement of vehicles.
Is it possible to have combo box with all employee names ,and acording to that choice to execute query.
So when i open my report I want to be asked to pick name of 1 employee in drop down menu and then get his records.
If its doable please be gentle cause i am new in all this
thx

 

[ajetrumpet]

You're going to apply the "query by form" technique here. Check out the FAQ on this subject before you do anything:

http://www.access-programmers.co.uk/forums/showthread.php?t=103312

You may be able to ask specific questions about what you don't understand after reading through that. It's a good read, and not too long...

 

[ACCESS NEWB]

thats not what i want
I would like,that when i open query (or report based on that query) to have option to choose among all employees ( thats 1 of the field in query) in drop down menu,so I dont have to type any name.

 

[ajetrumpet]

thats not what i want
I would like,that when i open query (or report based on that query) to have option to choose among all employees ( thats 1 of the field in query) in drop down menu,so I dont have to type any name.

You cannot choose an employee's name from a dropdown menu WHILE the report is opening. That is called a dynamic parameter. With those, you'll need to type a name in a parameter box.

If you want a list of anykind (like a combo box) to choose from, so you don't have to remember all of the names, you will have to pick from the list BEFORE the report/query is opened.


An example would be to select an employee name from a combo, then push a button that opens the report. This kind of process would use the QBF technique you read about in the article.

There is no other way to do it (not that I'm aware of anyway). Sorry...