Consulting

Results 1 to 2 of 2

Thread: Afterupdate help

  1. #1
    VBAX Newbie
    Joined
    Aug 2018
    Posts
    1
    Location

    Afterupdate help

    Hi all

    I have a simple problem I know how to solve but I believe there is a smarter way to do it.

    I have 10 textboxes and at the bottom, I have a button.

    The button should only be enabled if there is made any updates in either of the textboxes.

    I use this code for each field:

    Private sub "Fieldname1"_afterupdate()
    Button.Enabled = True

    End sub

    Is there a method were i do this for all fields?

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    The Form's After Update procedure should do the same thing regardless of which field is updated.
    I would add a

    Button.Enabled = False

    to your Form's On Current Event procedure to ensure the button his hidden when the record changes.

Posting Permissions

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