Synchronized forms (1 Viewer)

[pstraszynski]

Form 1 has a command button that opens a second form. Both forms show data from the same table.

How can I get Form 2 to open on the same record as Form 1? (i.e. navigate to record 5 on Form 1, then click the command button. Want record 5 data to appear on Form 2.)

 

[neileg]

Two approaches

1) Instead of a second form, use a subform. Make this invisible until the button is clicked.
2) Forms should be based on queries, not raw tables. In the query on which the second form is based add a criterion to the PK field that reads the value from the first form for the PK. The syntax for the criterion is Forms!NameOfFirstForm!NameOfPKControl