Add new record to different table

Using Access 2007 on Windows XP or Windows 7.



I have two tables (tblvariables and tblEEGvariables). They are linked by a primary key (MRN) and a foreign key (studyday). I have developed a form using a recordsource query that includes fields from both.

How can I add a "new record" - one for tblvariables (for each new patient) and separately into tblEEGvariables (for each day of EEG - multiple per patient) - using two buttons within the form?

I'm not adverse to using VB but I have no experience in it so your patience is appreciated!

Do not join these tables in one form RecordSource. You need a form/subform arrangement. Main form bound to tblvariables, subform bound to tblEEGvariables. A subform container control on main form will hold the subform. Master/Child links properties of the container control will synchronize the related records.
Access Help has guidelines on creating form/subform.

Great - thank you! I think that might work...