Programming VBA to run every time a different record on a form is accessed

[omahadivision]

Hello all,

I have a bound checkbox that determines whether or not a tab on my tab control is visible using the following code:

If FTIR1Checkbox = True Then
Me.TabCtl689.Pages(0).Visible = True
Else
Me.TabCtl689.Pages(0).Visible = False
End If

My question is, how can I make my database run this code every time a different record is accessed? Currently, I've programmed it into a click event, so it only changes when the box is actually clicked. I tried OnLoad to no avail. I have some records where the box is checked and others where it's not, and I'd like the tab to automatically be visible or invisible based on whether the box for that particular record is checked.

Thanks!

-Dave

[June7]

Put it in the form Current event.

[omahadivision]

Easier than I thought. Thanks!

[Missinglinq]

At some point, when using the Form_Current Property, you may need to differentiate between a New Record that is being 'visited' and an Existing Record.

Code for a New Record, only:

Private Sub Form_Current()
 If Me.NewRecord Then
  'Code for New Record goes here
 End If
End Sub

Code for an Existing Record, only:

Private Sub Form_Current()
 If Not Me.NewRecord Then
  'Code for Existing Record goes here
 End If
End Sub

And, if you have one task to be done on a New Record but another task to be done on an Existing Record:

Private Sub Form_Current()
 If Me.NewRecord Then
  'Code for New Record goes here
 Else
  'Code for Existing Record goes here 
 End If
End Sub

Linq ;0)>