Results 1 to 2 of 2

How to reference the current record from a form based on a query then use it to lookup from a table

  1. #1
    dtimpf is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    1

    How to reference the current record from a form based on a query then use it to lookup from a table


    I have an Access Form based on a query and want to use a field from the current record to look up and retrieve matching records in a table. Then I want to show the matching records in another form. How can I do this? The lookup value is not stored in a control. My preference is to generate the lookup with a Command button that references the field value from the current record. Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    6,948
    this is what a sub form is for.

    make a query that looks at the field on the master form, i.e
    select * from table where [field]=forms!fMasterForm!txtBox

    use the controls, thats what theyre for.

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

Similar Threads

  1. Replies: 5
    Last Post: 02-25-2018, 11:35 PM
  2. Replies: 5
    Last Post: 11-07-2017, 05:00 AM
  3. Replies: 3
    Last Post: 11-22-2015, 10:01 AM
  4. Replies: 2
    Last Post: 04-02-2013, 01:24 AM
  5. Query based on current record in form
    By bhsvendbo in forum Queries
    Replies: 1
    Last Post: 06-01-2010, 10:20 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
  •  
Tech Forums: Microsoft Office Forums