I need an event to fire when a user clicks on the Add Asterik at the bottom of the form denoting that the form is now in add mode. If there was an event such as WhenFormIsInAddMode or WhenFormIsInEditMode that would be ideal but since there isn't I'm at a loss of how to handle this. I could put Add or Edit buttons on the form and fire an event using the onClick event of the buttons but I want to use the default navivation buttons at the bottom of the form. Would appreciate any comments.


Greg

You may can use the .NewRecord property in conjunction with the On Current event of the form.

Private Sub Form_Current()
If Me.NewRecord Then
&nbsp ' do whatever you want if it is a "New Record"
End If
End Sub

HTH
RDH