Need to change drop down list options based on check box in table.

[jtm013]

Hello,



I have a database with a drop down list currently on the form. The list contains names.
This database goes back several years and some of the names on this list are A) no longer around B) no longer authorized users of this form/database.
I added a checkbox field to the table which is source for this drop down list. What I would like is for only the names which are checked in the table to appear in the drop down list. I have no idea how to do this. Any ideas?

Thank you in advance for the help!

JT

[John_G]

Hi -

The easiest way to do this is to create a query which selects only the records you want, i.e. the ones which are "checked", and then use that query as the row source for the dropdown list, instead of the original table.

John