Link records in two forms (1 Viewer)

[robert693]

I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second query performs calculations from information from the first. I would like to have the second form open at the same record as the first. In other words it perform the calculation on the record that is current on the form. Right now the second form opens on the first record. Any help would be greatly appreciated!

 

[Travis]

Set the Second Queries "Where" parameter to the Unique ID field of the Form.

Example: =Forms![YourFirstFormName].[Unique ID Field]