is there anyway to run vba on the first record only? I want to run a conditional statement during the OnCurrent event. Something like
Code:
Private Sub Form_Current()
On Error GoTo Form_Current_Err
If Form = FirstRecord Then
MsgBox "First Record"
End If
Form_Current_Exit:
Exit Sub
Form_Current_Err:
MsgBox Error$
Resume Form_Current_Exit
End Sub