Results 1 to 6 of 6
  1. #1
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176

    Is ther a way to make it so that data cannot be edited in a form?

    I have a View (seach included) form and an Input Form.
    I do not was users to be able to edit the data shown in the View form.
    I cannot put int a table because there are a bunch of check marks that I have aligned in a certain.
    I was thinking that I could have a report inside a form but I would like to stick with the form I have.

    Is there a way to do this?



    Thanks!
    Last edited by offie; 06-27-2013 at 02:09 PM.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Check out the Allow Edits property of the form (and Deletions, Additions if appropriate).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176
    Ended up going with Locked properties, thanks didn't know there was so many properties

    Thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    No problemo!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by offie View Post

    ...Ended up going with Locked properties...
    Sure, because the 'View Form' was also a 'Search Form' you had to use the Locked Property of each Control, rather than the Form's AllowEdits Property; setting AllowEdits to No prevents entering/selecting a search criteria.

    So many Properties, so little Time!

    Linq ;0)>

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Quote Originally Posted by Missinglinq View Post
    you had to use the Locked Property of each Control, rather than the Form's AllowEdits Property
    Well, "had to" isn't accurate, since it can be done by toggling the AllowEdits property in the appropriate events, but using the Locked property is simpler if the form is only used for read-only viewing.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 10
    Last Post: 08-02-2012, 08:32 AM
  2. Devil's form can not be edited!!!
    By albe_ACC in forum Forms
    Replies: 3
    Last Post: 10-26-2011, 02:38 PM
  3. Replies: 1
    Last Post: 08-29-2011, 09:31 AM
  4. Make a form with data across several tables
    By goodguy in forum Access
    Replies: 2
    Last Post: 07-15-2011, 02:27 AM
  5. form not letting records be edited
    By stuart rose in forum Forms
    Replies: 3
    Last Post: 09-02-2009, 04:22 PM

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