subform lock

P

Pam Coleman

Is there a way to lock in a subform to the main form. My main form has
information that is filled in when an emp # is entered. The subform is where
entry is made based on the emp # so there may be many subforms attached to
this number. Problem, when the form is opened it shows the last subform
entry and there is no main form infor attached. I want the main and subform
to be blank when the form is open and someone said you had to lock the
subform. I am a novice to access and do not know how to write any code. I
was wondering if there is a way to do this in the properties. Thanks,
 
T

tina

what table is the main form bound to? what table is the subform bound to?
how are the two tables related? and what are the names of the fields in the
two tables that are linked?
The subform is where
entry is made based on the emp # so there may be many subforms attached to
this number.
Click to expand...

do you mean to say that there may be many *records* displayed in the single
subform, for a single employee record in the main form? also, open the main
form in design view and click on the subform control; in the Properties box,
what are the values of the LinkChildFields and LinkMasterFields properties?
 
Top