Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    5

    Unanswered: Form to Query Help

    Hello,

    Here is my situation. I have a two tables, one table is Service_Center and one is Semester_Memberships. Semester_Memberships lists each person individually who holds a membership.

    I have a form (Service_Center) attached to the Service_Center table and on the form is a text box for Last_Name and a bound Yes/No field for Semester_Towel. When someone clicks the Semester_Towel check box I want a query to run using the last name currently showing in the Service_Center form and look in the Semester_Memberships table for a matching last name.

    I know I have to add an expression in the AfterUpdate of the Yes/No field, but I can't get it to work.

    Thanks!

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    You could use a DLOOKUP.
    What would happen if two members have the same Last Name?

  3. #3
    Join Date
    Apr 2009
    Posts
    5
    Any idea on how to use DLookup? Where would I place it? In the Query, AfterUpdate, or where?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have you tried using help at all?

    You can learn stuff like "how to use DLookup" quite easily yourself by searching through help.

    It also helps if you answer our questions too.

    Quote Originally Posted by Poppa Smurf
    What would happen if two members have the same Last Name?
    What happens when the user navigates records? Is the Yes/No field bound? If it is I'd put it in the query.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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