I cannot think straight today. I have one main data entry form which enters data into one main table.
Linking into certain fields within the main table are other tables which supply data to the combo boxes (e.g. tblAccountManager - a separate table provides a list of colour schemes to the drop-downs in the colours field of the main table/form.
If I enter a new name (which is not on the drop-down) directly into the form it is entered, but is not added to the tblAccountManager table.
The Row Source Type is "Table/Query"
The Row Source is "SELECT [tblAccountManager].[AccountManager] FROM [tblAccountManager];"
I am sure I am doing something basic wrongly but I have confused myself on this one.
Linking into certain fields within the main table are other tables which supply data to the combo boxes (e.g. tblAccountManager - a separate table provides a list of colour schemes to the drop-downs in the colours field of the main table/form.
If I enter a new name (which is not on the drop-down) directly into the form it is entered, but is not added to the tblAccountManager table.
The Row Source Type is "Table/Query"
The Row Source is "SELECT [tblAccountManager].[AccountManager] FROM [tblAccountManager];"
I am sure I am doing something basic wrongly but I have confused myself on this one.
