Linking forms

[Van T. Dinh]

I presume you are using the OpenForm Method in the
CommandButton_Click Event (in Form1).

In this case, you can use the "WhereCondition" argument to
filter the Recordset of the Form2 to the required Record
using to value on Form1 that uniquely identifies the
required Record in Form2.

Check A97 Help on the OpenForm Method for all arguments
you can use.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
(Access 97)
I have a form (form1) based on a query. When the form is complete there
will be occasion when more specific additional information is required about
a particular record. On those occasions I wish to press a command button and
a 2nd form to open up which is already partially completed from the
information in form1.
Whilst I can get the 2nd form to open, I cannot get it to infill the
information.I have tried to filter the information by using another query
and the best I can achieve is a box opening on screen asking me to type in
the parameter.. I was trying to achieve this

automatically via the query. (I