Need Help with sub form

[Theodore]

I need to auto populate a sub form.


Main Form

ID
Top Assembly Part Number
Top Assembly Serial Number


Sub Form (continuous form)
ID
Part Number
Part Name
Part Serial Number

(I have a separate table with sub form part numbers for each main form
part number)

Based upon the part number in Main Form I need to automatically
populate the sub form with ID, Part Number and Part Name.

Some Main Form Part Numbers have 85 sub form part numbers others as few
as 3 sub form part numbers

 

[Jeff Boyce]

Theodore

If you have a main form and a sub form, and, in design mode, insert the sub
form into the main form, Access tries to help you determine the connection
between the two.

First step would be to confirm that the Parent/Child fields in the sub
form's properties (found in the sub form control on the main form) are
properly set.

 

[Theodore]

Main Form & sub Form linked by id, I can enter data into sub form
manually just fine. When I create a new record in Main Form I want the
sub form to automatically populate with the values from another table.

Based upon the part number in Main Form I need to automatically
populate the sub form with Part Number and Part Name.

Some Main Form Part Numbers have 85 sub form part numbers others as few
as 3 sub form part numbers

 

[Guest]

When I create a new record in Main Form I want the sub form to
automatically populate with the values from another table.

A new record in the main form would be a totally new item and therefore the
subform (item table) would have no records at that time.

Unless you are creating a new record of the same “Top Assembly Part Numberâ€
with a different “Top Assembly Serial Number.â€

Then you need an event or macro that runs an append query using the main
form “Top Assembly Part Number†as criteria and inserting the main form “IDâ€
and all items matching the “Top Assembly Part Number.â€