Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    18

    Unanswered: auto update a check box

    My problem:

    I want to be able to populate a form and when I hit enter/add record, an associated record in a separate table is updated with a check in a check box.

    Example:

    Customer Info table has the Customer ID field
    Customer Payment table has the Customer ID field

    When I fill out the Customer Payment table and hit enter, I want the associated check box / record in the customer info table to be auto updated without me having to physically check the box.

    The above fields illustrate what I want to happen but are purely for example. I will not have to clear the check box in the associated table for my DB because the event ( sub report) can only happen once.

    Is this possible?... I am fairly novice but getting much better.

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Check out (in you Access help system) about Relationships. Read up on it.

  3. #3
    Join Date
    Sep 2003
    Posts
    18

    Wink

    Originally posted by CyberLynx
    Check out (in your Access help system) about Relationships. Read up on it.
    hmmm... did I mention I was a novice at this? Your post is a bit cryptic.

    Scryma

Posting Permissions

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