Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Kenton, Delaware, USA
    Thanked 0 Times in 0 Posts

    Reenable Command Button (Access 97)

    I have a command button on a survey form that quits (I simply called it Q)that is NOT enabled, because I don't want the user to exit until certain rules are met. When the form closes it asks if the user wants to go back to the survey form which has not closed yet but has saved the record. All of the closes are tied to before updates because of rule validating. At this point all the rules have been met so I don't care when the user quits the survey. However when the second form closes and the survey form is open the close buttons will not work on the survey form. What I want to do is set the properties of the Q button on the survey form to enabled when the secondary form closes. How do I do that?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Reenable Command Button (Access 97)

    Is this a bound form? If so, you can put code in your OnCurrent event to detect if this is a NewRecord or not.

    Commandbutton.enabled= not Me.NewRecord
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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