Combo Box in query

[Age of madness]

Hi

Am getting my head round access bit by bit. I am curently trying to figure out how to use a combo box to specify a list of choices to return in a query.

for example i have a number of departments that have data stored for them, i can run a paramater quey for the user to type in the name of the dept they want to view, but i want them to be able to select whih dept from a drop down list (combo box).

Any help would be apprecited on this.

Daniel

 

[giacomo]

Hi Daniel,

In order to do this you will need to create a form. Check out the link below and look for "Creating a form to supply parameters to a query" about a third of the way down...

http://office.microsoft.com/en-us/assistance/HA011170771033.aspx


hth,
Giacomo

 

[Age of madness]

thats got it sorted

Very much appreciated

 

[giacomo]

no problem. glad you got it working.

Giacomo