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.