Problem with combobox in form

[SGrohola]

I'm in the process of setting up an Accident database. I have a query which is what I using for my form. In the query, I'm using a main table (tbl_General Info). This table has 2 comboboxex which are linked to other tables (tbl_terminals & tbl_regions), pulling 1 column. for each, as a drop-down. I also have another table (tbl_Driver Info).



In the query, I have all the fields from tbl_General Info (which includes the comboboxes), and then 1 additional field from tbl_terminals, and 1 field from tbl_Driver Info. When I run the query, it runs fine, and let's me change the terminal in the combobox field, and the region in that combox, after I run the query, and saves the query.

I'm using this query to set up my form, and when I bring the form up in "Form view", and select the drop-down for terminals or for regions, it will let me make a different selection from the combobox, but then, it will not save the form, and gives me an error.

[RuralGuy]

It sounds like you are using lookup fields in your tables. https://btabdevelopment.com/how-to-r...t-table-level/

[orange]

This table has 2 comboboxex

I agree with Allan. Most developers will advise you to not use Lookup fields in tables. Best practice is to use Lookup tables and relationships.

[RuralGuy]

Our basic code of conduct. http://theaccessweb.com/tencommandments.htm