How to open a form with several records already added by default

[NicksMovement]

Hi, all.



I've created a form that I'd like to open and default to 7 records that can be further manipulated by choosing values in the form footer.

I am not so well versed in code to know how to add multiple records so that is the reason I'm here (just to be clear).

I'm also not attached to the layout here. If for whatever reason this doesn't seem ideal from a developer perspective I am open to other suggestions. I know I could split this up into separate tables (say, posts and plates) but a majority of the jobs end up like this form and I also wanted to account for any discrepancies by giving the user the ability to add extra component types and components.

below is what I'd like to have populated when the form is opened and then they can select items in the footer to customize the project. ComponentTypeT and ComponentT are the relevant tables that I'm pulling data from.

Component Type	Component	Ft.	In.	Qty
*combo box*	*combo box*	user input	user input	Auto Populate
Base Plate	pl1			X+Y
End Column	col1			X
End Arm	arm1			X
Int. Column	col2			Y
Int. Arm	arm2			Y
Gusset Plate	pl2			X+Y
Flange Plate	pl3			2*(X+Y)
Potential new record
Potential new record
*Form Footer*
Scenario	(Drop Down)
End Qty	X
Int Qty	Y

By using

If IsNull(ComponentTypeIDCombo) Then
ComponentTypeIDCombo = 3
Else: Exit Sub
End If

For example, I can add the first record. I'm not exactly sure how to add the component and then jump to the next record from there.

I'm happy to give more clarity. Any advice on this would be helpful and thank you for reading this far.

-Nick

[June7]

Not understanding db structure. Is this a manufacturing/assembly type of db? What are ComponentTypeT and ComponentT tables for? Are these both lookup tables? What table is the form intended to save records into? What is the identifier field that these records are related to?

What criteria determines the 7 components to create records for?

Really need to see full db structure and sample data. If you want to provide db for analysis, follow instructions at bottom of my post.