Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check box (97 sr2)

    I have a form which has a check box, a text box and a command button(in addtion to several other text boxes).
    What I trying to do is when you click on the check box and then hit the command button a query runs that puts the date() into the text box.
    What is happening is I seem to be locking myself up. I will get the message that I am in conflict with another user, when I hit save the changes the date appears in the text box and the check in the check box is not there. The opposite happens if I hit drop the changes.

    This form is based on a query.

    I am puzzled, any help would be appreciated.

    Thanks

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Check box (97 sr2)

    Try putting the Date directly into the text box on the form, rather than using a query which puts it directly into the underlying table.

    me![txtDate] = Date

    Replace txtDate with the actual name of the textbox
    Regards
    John



Posting Permissions

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