Drop down menu for Query

[martin617]

I have produced a database which keeps a recored of all the IT equipment in my department. I am trying to produce a report which will tell me which PC have a certain piece of software on them (so i know which need upgrading).

I have built the query find (to lead onto the report) but I would like "box" which askes which software I am looking for to be a drop down box. I have a table with all the availble software on which is used in the database.

And this feature would be helpful for other users who do not know which revison of the software they are looking for.

Is this possible? This is my first Access database and have had to teach my-self. So I am new to VB as I have been manly using the wizards but have just completed some small bits of VB.

Any help will be greatfully recived.

Thanks
Martin

 

[spiralmind]

create a combobox control

set its rowsource to a query that returns all software items you want the user to choose from

you probably don't have to set the control source to anything - comboboxes used as parameters in other queries are usually best left unbound