A data prompt that is a combo box.

[Guest]

I have a query that prints out an IT inventory for a particular department at
work. When you run the query it prompts you to input the name of the
department. I am hoping it is possible to make this prompt a combo box so
that instead of having to remember all the departments exactly, you can just
choose. There is a table that has all the department names available.

Thanks for any help on this...

 

[Guest]

You need to create a form. Place a combo box control on the form, let the
wizard create the combo using your departments table. In the criteria column
of your query for the department you can then enter

[Forms]![FormName]![ComboBoxName]

With your form open you can then select the department from the combo box &
your query will display data just for the department selected.

 

[Shotodru]

It is possible to make this into a combo box. The recordsource property may
be set to a field in a particular table containing only the list of all the
departments. This is more of an easier dynamic approach. Alternatively, you
may just type in the names of the departments separated by commas, in the
recordsource property.

Hope this helps.

Best regards,
Satadru

 

[Guest]

Thanks John,

the problem had to do with types. The new form was returning a id number
and i was querying for what the number pointed to. All fixed now.

-marti-