Creating/Editing A Combo Box From a Table
Once you click on "Table/Query", your property sheet will automatically add another data item labeled "Row Source". It should look similar to this:
Next click on the "..." box, which automatically brings you to this screen:
Then find the table that has the information for the drop-down menu. When you double click it, it will be added to the page, but you still need to double click on the field name to add it to the Row Source. When finished it should look like this:
Now just close this window. As you exit, it will prompt an "SQL error message". This is okay, click "Yes" and go to "Form View" to double check it works.
Once you have linked the Combo Box to a certain table, you will just need to edit the information within the table to change the data in the drop down menu. For example, each semester the intern names will change, so a staff member will need to change the "Intern Full Names" table to reflect the names of the new interns.
