I have a form which uses two tables. It's not a split form. The "primary key in one table (tblCallLog) is linked to the foreign key in the second. (tblContacts)
I use the following code to browse to the code and add a new record to the table.
Code:
DoCmd.BrowseTo acBrowseToForm, "frmCallLogMain",,,,acFormEdit
Docmd.GotoRecord,,acNewRec.
This get's me to where I want to go, but if I save the record after changes I wind up adding a new record to the tblContacts as well as the tblCallLog.
Here is a picture showing part of the form.
The Full Name field is combo unbound control, but the row source is CFullName in tblContacts.
The fields below up to CEmail are all controls bound to fields in the tblContacts. The remaining controls "CL" are bound to fields in the tblCallLog.
I know seeing more of the code would be more help, however I'm just looking to see if my logic is correct at the top level when i use the two lines of code.
Does it save to both tables?
Thanks for any help.
Jeff