Cisco February 2016
1) If with 'blank' you mean 'empty': look at point 2)
2) In the recordset of your subform you MUST have the field Visit_ID.
If you don't want to show it in the subform set it to
3) Link the two forms (main- and sub-) with
Link Master Field and
Link Child Field in the Main form 'Data' Property Sheet TAB.
4) In the subform, in the
before_Update event set
Sub Form_BeforeUpdate(Cancel As Integer)
Visit_ID = Me.Parent!Visit_ID
(supposed that Control Names are equal to the Field Names).
This will ensure that all records in the child table
related to one record in the table
Hope this helps.