All,
Here is the layout of the project:
Form that pulls data from a Sharepoint List into a linked table via the external data option.
This list contains about 40 fields per record, so I created three maketable queries for the three tables that I need to populate some combo boxes because I don't need all the fields, just needed 4.
All three tables have 4 columns [ID(autonum), Name(Text), Active Employee?(Boolean check), Qualifications(memo that holds check box data)] after the maketable is executed.
Table names: VTS_WS, VTS_AWS, VTS_Operators
I pass a SELECT statement in the Row Source to populate each combo box: SELECT VTS_WS.Name FROM VTS_WS;
I left the Control Source box empty, thus unbounding the Combo box.
The issue is when I open the form, the fields are empty. I can select an option from the combo box without a problem, but after I save the record, the combo boxes turn into: #Name?
I can still go back and manually select an option from the combo box, but would like to have the previous value persist in the field.
Any thoughts?