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

[dtimpf]

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.

[ranman256]

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.