Linking 2 tables/forms?

[Kevo]

I have two tables/forms

tblLoad

LoadID - Autonumber - PK
LoadDate
AutoclaveID (machine that load is in)
LoadNumber (load number in this autoclave this day)
Employee


tblBIIncubation

BIIncubationID - autonumber - pk
LoadID


and many more....

We will use frmLoad for every Load.....but, we only use frmBIIncubation on about every 4th or 5th Load (Test we have to run on certain Loads)


Currently, when you open frmBIIncubation the LoadID ctl is just 0.....I have not assigned a control source.....

So, my question is...How would you link these two? I don't want the operator to have to use a look-up for LoadID because it is an autonumber and would mean nothing to them.

I'm not sure the easiest way......
If I made frmBIIncubation a subform of frmLoad, could I make it available only if the operator toggles a ctl?

Can you make a subform (visible)?
Something like....

If ctlToggle = True Then_
Me.subform.Visible = True

And what if the subform was on a tab control? Could you make the tab visible depending on the toggle?

Thanks

[June7]

Can do either.

Example from my project to set tab visibility:

.tab1.Visible = True
.tab2.Visible = True
.tbxLABNUM.SetFocus
If Not .tbxSet Like "*1*" Then
.tab1.Visible = False
.ctr1.SourceObject = ""
End If
If Not .tbxSet Like "*2*" Then
.tab2.Visible = False
.ctr2.SourceObject = ""
End If

[Kevo]

Thanks, I need to think through this a little further and experiment a little before I ask any other questions.

I want to make sure I havent missed anything else.