Form question

  • Thread starter Thread starter ~*Cindy*~
  • Start date Start date
C

~*Cindy*~

Hello,

I have a form and a table, id like to have a subform that
is in a datasheet type format, and id like the main form
to have this subform on it (ive done that). But id like
textboxes on the main form to fill out the subform (to
add records), how would i go about doing this? Thanks.

Cindy
 
I'm not sure I follow exactly but it sounds like you have a main form with a
records source. a sub form with related records from another source,

MainForm: COMPANY
SubForm: EMPLOYEES

You select a Company on the main form, and populate the Sub Form with
Employees at the selected company.

You do that by setting a property on the sub form that will map the
Company.CompanyID of the main form to the Employee.CompanyID on the subform.
When you add records to the sub form the will automatically be assoicated to
the selected company.

Hope this helps.
 
Back
Top