Results 1 to 3 of 3

Thread: Replace (2003)

  1. #1
    Star Lounger
    Join Date
    Apr 2004
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replace (2003)

    I have a form with two check boxes and an Update command button that runs a query. When the query is run I want the value of a field for all records in the query to change to true or false based on which check box is checked. I've tried writing an expression in the query referencing the form check boxes but I'm not able to get the values to change. Any suggestions on how to do this?

    Thanks,

    Kent

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

    Re: Replace (2003)

    You must refresh the form after running the update query:

    Me.Refresh

    This forces the form to update the displayed values.

  3. #3
    Star Lounger
    Join Date
    Apr 2004
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replace (2003)

    Thank you much!

    Kent

Posting Permissions

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