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:
Code:
Private Sub Form_Current()
If Me.NewRecord Then
'Code for New Record goes here
End If
End Sub
Code for an Existing Record, only:
Code:
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:
Code:
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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007