Subforms

[mfk90]

I have a field in my employee table called NOTES. I also created a NOTES table and they are linked on employeeID.

Hoe can i create a subform to enter notes? Confused! Thanks

[Narender Sagar]

Just link EmployeeID with the EmployeeID of Notes table. you can set default value of EmployeeID from the parent table, and you can maintain the Notes. Pl. feel free to ask if required.

[Seth Schrock]

A subform is just another normal form placed in a subform control. So all you have to do is create a form bound to your notes table, then go into design view on your parent form and add a subform control. If you have the control wizard turned on, it will ask you to create a new form or use an existing form. Choose the later and then select the form. It will then ask you what fields link the main form to the subform. Choose the appropriate fields and then you are done.