E
ERIC ANDERSSON
I have a form that will not let me update the values for certain
fields. The form is based on a query. The query is made up of a main
table with relationships to 8 lookup tables. I have an "add record"
button on the form set up by the wizard. After clicking the add
button, all the fields go blank (as expected) I can then pick values
from the combo boxes (that are tied to the various lookup tables) but
I can't put in values for the text boxes that are located in the main
table.
However, if I add a record without anything in the text boxes located
in the main table, I can then open the query directly and change the
values in the fields of the new record to what I want.
The relationships for all tables are one(lookup table) to many(the
main table). Referential integrity is checked. The form is set to
dynaset (when using dynaset-inconsistent updates I can then add
values in the text boxes but not the combo boxes).
What do I need to change to allow me to enter data in the text boxes
and the combo boxes at the same time?
fields. The form is based on a query. The query is made up of a main
table with relationships to 8 lookup tables. I have an "add record"
button on the form set up by the wizard. After clicking the add
button, all the fields go blank (as expected) I can then pick values
from the combo boxes (that are tied to the various lookup tables) but
I can't put in values for the text boxes that are located in the main
table.
However, if I add a record without anything in the text boxes located
in the main table, I can then open the query directly and change the
values in the fields of the new record to what I want.
The relationships for all tables are one(lookup table) to many(the
main table). Referential integrity is checked. The form is set to
dynaset (when using dynaset-inconsistent updates I can then add
values in the text boxes but not the combo boxes).
What do I need to change to allow me to enter data in the text boxes
and the combo boxes at the same time?