Results 1 to 2 of 2
  1. #1
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    What happened to my properties?

    Among my DB forms is one which is opened with a DoCmd.OpenForm as either Edit or ReadOnly. The form and subforms as developed have property settings of dataentry=false, Edit=true,delete=true,additions=true.


    If a user with appropriate authority logs in, the form and subforms should open with Edit privileges and have the properties described above. All other users will open the main form as ReadOnly. I'm not sure what that does to the property settings in the subforms.
    However, from time to time, when the DB is opened, the subform properties will all be set to false, i.e. no editing, no additions, deletions, or data entry. Once that happens, I have to open the subforms in design view and reedit and save the properties. Opening the form while signed in with authorization doesn't return the properties to the Edit mode.
    I just ran a test using openForm with Edit and then with ReadOnly and there wasn't any change in the property settings above in the main form of the test. I didn't try to extend the test to subforms.

    Any guesses as to what I'm missing?

    Thanks for any feedback.
    Last edited by hertfordkc; 11-12-2011 at 01:51 PM. Reason: Omitted sentence

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Are you allowing forms to be closed with the X button? Maybe the close is saving with revised property settings. I disable the X button and use custom button with code and I never have this issue:
    DoCmd.Close acform, Me.Name, acSaveNo
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. what happened to radio buttons?
    By judomum in forum Forms
    Replies: 1
    Last Post: 10-09-2011, 11:58 AM
  2. What the world happened!
    By SemiAuto40 in forum Programming
    Replies: 2
    Last Post: 10-03-2011, 10:59 AM
  3. Form Properties
    By Desstro in forum Access
    Replies: 3
    Last Post: 04-10-2011, 05:54 PM
  4. Replies: 3
    Last Post: 01-20-2011, 05:23 PM
  5. Form Properties
    By mwabbe in forum Forms
    Replies: 3
    Last Post: 09-23-2010, 10:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums