Limiting Navigation buttons on form

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top