• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Access Form: allowedits false not allowing changing pages

Dear experts -
I have a multi-page form, that uses an option group to change pages. We change pages with this code:
miFrame2 = Me.Frame43
    Me!TabCtl165 = Me!Frame43

We have now added code in the Current event that, based on the user's access level, either allows or does not allow edits/additions/deletions. If this variable causes the allowedits/deletions/additions to be set to false, then this option group does not work.

any ideas?

Many thanks!!
  • 2
1 Solution
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
That's by design.  Not allowing prevents Option groups for working, as well as not allowing Combo boxes to be selected, even if unbound.

Try Locking controls instead of not allowing Edits.

terpsichoreAuthor Commented:
worked very well. thanks.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now