Seems to have found the trick ! I've used the wizard to design form and subform. My first try was to use form and a nested subform as a solution to the problem.
I've given up because of the coding difficulties i've found when working on
the subform. Although, the wizard asks how u want ur design: #1)form - subform or
#2)form - linked form. I took for granted that either way would ask the
user with same input when prompted. Although, the alternative #2 needs an extra input: the link field value between the two forms. As i have had settled the
text box property to Vesible = No, which worked OK on #1, the error message" ...Record required" was displayed on #2.
rgds P.

The message you indicated is the last I mentioned where your referential integrity is preventing you from adding a record. I think you discovered that the reason this doesn't work was that you hadn't properly linked the subform using the Master/Child Link Fields. When you tried to enter data, in the subform, it didn't know which employee you were trying to add it to. In fact, it was likely trying to add it to a Null Employee ID.

So just set up your Master/Child Link Field properties correctly.

By the way, you don't have to create a field for the ID field. As long as the ID field is in the Record Source for the form, it will work.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

I meant to say that you don't have to create a field on the fsuborm for the ID field and then make it Visible = False. As long as the field is in the Record Source for the subform you can use it for the Child Link Field.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

I've used the MsAccess wizard-form to create the form - linked form. I have
chosen the link alternative and have made Visible=False for the ID field.
So, when asked to fill the ID field, the field was not displayed. I would
suggest that Ms form wizard links the fields as it does when form and nested
subform alternative is chosen.
Thanks u all.
rgds P.