W
Wendy
I have a combo and several text boxes in my header (Person's Name, Date,
etc.) that I want to be recorded in every record without the user having to
enter it each time in the detail part of the form. I tried two different
methods I found from another post and neither worked.
One was the before insert, set the value in the detail area equal to that in
the header.
Example:
Private Sub Form_BeforeUpdate(Cancel as Integer)
me.txtCoord = me.cboCoordinator
me.txtDate = me.txtCurrentDate
End Sub
The other was to set the default of the text box in the detail section = to
the text box in the header.
Basically, nothing is happening with either method. the text box in the
detail section stays blank, except for in the first record.
I don't know VB and am not an experienced Access user, so any help is
appreciated. Thank you!
etc.) that I want to be recorded in every record without the user having to
enter it each time in the detail part of the form. I tried two different
methods I found from another post and neither worked.
One was the before insert, set the value in the detail area equal to that in
the header.
Example:
Private Sub Form_BeforeUpdate(Cancel as Integer)
me.txtCoord = me.cboCoordinator
me.txtDate = me.txtCurrentDate
End Sub
The other was to set the default of the text box in the detail section = to
the text box in the header.
Basically, nothing is happening with either method. the text box in the
detail section stays blank, except for in the first record.
I don't know VB and am not an experienced Access user, so any help is
appreciated. Thank you!