I'm using the same form to enter and browse records. I would like to make the navigation buttons invisible when user enters records and visible when users are browsing through them. Is there away to code this on the form? Thanks.
Private Sub Form_Current()
If Me.NewRecord Then
Me.NavigationButtons = False
Else
Me.NavigationButtons = True
End If
End Sub
Private Sub Form_AfterUpdate()
Me.NavigationButtons = True
End Sub
You'll either have to use the Record Menu to save the record, since you cannot move off of a new record with the nav buttons gone, or add a custom "Save" button if the form is a Single View or Continuous View form.