G
Guest
I have a form which reads data from a query joining two tables.
tbl1 has two fields, an autonumber and an integer
tbl2 has people information (name, address, etc.) and a link to the
autonumber in tbl1
the form shows the integer from tbl1 and all data from tbl2.
when I put the form in "new record" mode, I can create the integer field in
tbl1 but all of the remaining fields are locked on the form and I cannot add
the information. The form is not in dataentry mode by default. and the
button that puts it into add new record mode was created using the wizard
when the button was added to the form.
I am relatively sure this is a easy fix but it has been a long time since I
developed in Access.
Thanks in advance for any help you can provide.
tbl1 has two fields, an autonumber and an integer
tbl2 has people information (name, address, etc.) and a link to the
autonumber in tbl1
the form shows the integer from tbl1 and all data from tbl2.
when I put the form in "new record" mode, I can create the integer field in
tbl1 but all of the remaining fields are locked on the form and I cannot add
the information. The form is not in dataentry mode by default. and the
button that puts it into add new record mode was created using the wizard
when the button was added to the form.
I am relatively sure this is a easy fix but it has been a long time since I
developed in Access.
Thanks in advance for any help you can provide.