Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Checkbox and Query help needed please!

    I want to enter a value eg a date (12/12/05) into a textbox on my form. When I enter the value I want a checkbox on the same form to uncheck itself.

    The textbox and checkbox are both fields on the same query.

    Any help will be very helpful!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    There are various routes to achieve what you want. In essence write a function which tests if the value in the text box is a valid date, and if so either returns thge result of that test or sets/clears the checkbox. Its up to you to decide which.

    you then need to place a call to the function in events within the form
    you could place the code in the text boxes on 'lostfocus' event
    you could place the code in the forms 'beforeupdate' event
    you could place the code in the textbox 'beforeupdate' event
    you could place the code in forms 'oncurrent' event to set the checkbox on change of record


Posting Permissions

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