Form/Subform problem

[UT227]

I'm using the tabbed feature to have subforms in a form. Unfortunately, it's possible to add information in the subform even when the main form is showing NEW. So, the subform information isn't related to anything. How do I make it so that the subform cannot have information added until the main form has been created?

[isladogs]

You could hide the subforms by default and only make them visible when there is data in the main form.

[Missinglinq]

I've used this before:

Private Sub Form_Current()
  
 If Me.NewRecord Then
  Me.SubFormName.Locked = True
 Else
  Me.SubFormName.Locked = False
 End If
 
End Sub

Private Sub MainControl1_AfterUpdate()

 If IsNull(Me.MainControl1) Then
  Me.SubFormName.Locked = True
 Else
  Me.SubFormName.Locked = False
 End If

End Sub

Note that SubFormName is the name of the Subform Control...not the Form that resides there...which may or may not be the same!

Linq ;0)>

[UT227]

That got me thinking a bit better. I tried something simple:
Private Sub Form_Current()
If IsNull(IncidentID) Then
Me.tabICS209.Enabled = False
Else
Me.tabICS209.Enabled = True
End If
End Sub

Would this work?

[UT227]

You're code worked well. Do I need the after update also or just the on current?

[UT227]

Had to take time away for a bit. That worked excellent. Thanks.

[Missinglinq]

Glad we could help!

Linq ;0)>