Limiting Navigation buttons on form

  • Thread starter Thread starter Damon Heron
  • Start date Start date
D

Damon Heron

With the standard navigation buttons on an Access form, is there a way to
limit the user from proceeding to a new record?
I have four objects with a subform to enter data on each. There are only
four. The user can navigate to a 5th(new) form. I have disabled the
controls on the new form, but it looks sloppy and may be confusing. I used
this on the form's current event:
(the ContTypeName control has a locked property set at design time)

If Me.ContTypeID > 4 Then
Me!ContTypeName.Enabled = False
Me![tblContSubform].Enabled = False
Else
Me![tblContSubform].Enabled = True
End If

thanks for any help.

Damon
 
Back
Top