Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: How to disable edition and deletion on form

    I have a button on a form called finish, once click finish, i would liket to disable all edition for each field on this form. How could i write a code? The name of the form called fmDataEntry. Thanks for you help.

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    So you want to no longer allow data entry? Why don't you just close your form?
    Ryan
    My Blog

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    Yes, this is the way i can do. As in the form i have other buttons such as "print" need to work on. If close it, they won't use other buttons.

  4. #4
    Join Date
    Mar 2004
    Posts
    660
    Otherwise, i could create another same form as data entry but disable the edition for this form. Do you have any best way to do it? Thanks.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    Me.AllowAdditions = False
    Me.AllowEdits = False
    'Etc
    Have a look at the properties similar to this that you can set for a form
    George
    Home | Blog

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Are you saying that once you click in the "Finished" button, you no longer want edits to be done on this particular record?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Mar 2004
    Posts
    660
    Quote Originally Posted by Missinglinq
    Are you saying that once you click in the "Finished" button, you no longer want edits to be done on this particular record?
    Once i click the "Finished" button, all the fields in the form shouldn't be edited.
    Thanks

  8. #8
    Join Date
    Mar 2004
    Posts
    660
    Quote Originally Posted by georgev
    Code:
    Me.AllowAdditions = False
    Me.AllowEdits = False
    'Etc
    Have a look at the properties similar to this that you can set for a form
    That is what i tried in the beginning. It didn't work. It still can be edited. Thanks.

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Bound or unbound controls?

    What did you try?
    George
    Home | Blog

  10. #10
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by yyu
    Once i click the "Finished" button, all the fields in the form shouldn't be edited.
    Thanks
    So you want to click this button, and then not be able to edit any field in any record in your form?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •