Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unchecking (2000)

    This seems soooo simple and I have spent the last 2 hours trying to figure it out!

    I have a form that my users will use to select the records that they would like to see in detail. It's basically just a datasheet. They put a check in a checkbox and click a button and are shown the records. When the close out of the form, I want those check boxes to return to 0 -- that is, in their unchecked status. I tried to write a Form_Close() procedure in order to change the values in these check boxes but I get run-time error '2448' that says that I can't assign a value to this object.

    ????

    Thanks,
    Kindra

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unchecking (2000)

    Why don't you put the code in the On Load or On Open event procedure? Or create an update query that turns off all "flags", and execute this query (DoCmd.OpenQuery).

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unchecking (2000)

    The update query works perfectly!

    However, how do I get those prompts notifying that I'm about to modify these records to stop showing up?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unchecking (2000)

    Put DoCmd.SetWarnings False before running the query, and DoCmd.SetWarnings True after it.

Posting Permissions

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