User Profile

Collapse

Profile Sidebar

Collapse
SclWrkr
SclWrkr
Last Activity: Mar 19 '12, 11:30 PM
Joined: Mar 14 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SclWrkr
    replied to How To: Disable button in subform until new record is created?
    in Access
    Hi NeoPa,

    Thanks so much for your prompt reply! I tried implementing the code as an Event in the subform property. When I compiled the code, the system threw an error: Invalid use of Null.

    Access would not let me use the procedure Form_Dirty(), so this is the code I ended up using. The procedure is the default if I go to Form->Properties->Event->On Dirty.
    Code:
    Private Sub Form_Dirty(Cancel As Integer)
    ...
    See more | Go to post
    Last edited by NeoPa; Mar 19 '12, 08:53 PM. Reason: Note: The button name has been changed to cmdEnroll, so this is correct in the code snippet - Mod added mandatory [CODE] tags.

      Leave a comment:

    • SclWrkr
      started a topic How To: Disable button in subform until new record is created?
      in Access

      How To: Disable button in subform until new record is created?

      Regarding command buttons in Access 2007 . . .

      Related to a similar thread, http://bytes.com/topic/access/answer...-if-field-null, I have a more basic question, but minimal VBA experience.

      I want to keep a command button on a subform disabled until the user enters data into any field-- in other words, enable the button as soon as a record is created and the EncounterID autonumber is generated (which...
      See more | Go to post
      Last edited by NeoPa; Mar 15 '12, 01:18 AM. Reason: Added mandatory [CODE] tags for you.
      No activity results to display
      Show More
      Working...