Results 1 to 2 of 2
  1. #1
    bqs is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009

    Cool Query based on specific form field value

    OK - I am a newbee to access in terms of using it to query and manipulate data so please bear with me.

    I have a table1 with multiple fields (field1, field2, field3) and table2 with multiple fields (field10, field11).

    I also have a form which pulls in the data from table1. Next to the field2 data in the form, I want a query based on the value of field2 in that record and lookup and display fields from table2.

    In other words, lets say I have a parts list which contains vendor info, price, date (contained in table1). I want to query the specific vendor (on the current record) and display more detailed information on that vendor (contained in table2).

    Please help since I know this is not tough but I just can not figure it out.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    trust you have an Access instruction book; you want to add a subform....the wizard will step you thru linking it on the shared field...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-05-2009, 07:22 AM
  2. Total based on Formula based on field value
    By cjbuechler in forum Reports
    Replies: 15
    Last Post: 07-10-2009, 09:56 AM
  3. query - criteria based on another row field value
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 05-29-2009, 04:17 PM
  4. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  5. Replies: 0
    Last Post: 04-17-2008, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums