How can I generate items in a drop down menu dynamically?

[Karen]

We are developing an application in which we want to dynamically populate the
entries in a drop down menu using data in a table. Has anyone done this?

 

[fredg]

We are developing an application in which we want to dynamically populate the
entries in a drop down menu using data in a table. Has anyone done this?

You would set the Combo Box's Rowsource to a query.
For example:
Select YourTable.[Department] from YourTable Order By [Department];