How to know.....

[Alain]

Hi to all,

Is it possible to know, by code or by function, when a new recordset is
being created when using the new record with the record selector at the
bottom of the form.

The reason is I do not want to create some navigationnal button ( including
a New Button) on the forms unless I really have to

Thanks for the information

Alain

 

[Dan Artuso]

Hi,
Try this:

Private Sub Form_Current()
If Me.NewRecord Then
MsgBox "new record"
End If

End Sub

 

[Alain]

Thanks Dan,
works great

Alain

Hi,
Try this:

Private Sub Form_Current()
If Me.NewRecord Then
MsgBox "new record"
End If

End Sub