Hi TKM,
you can do it like this:
DoCmd.OpenForm "NameOfForm", , , "[PKey] = " & Me.PKeyControlName & ""
replace :
NameOfForm with the name of the second form
[PKey] with the name of the primary key field on the first form
Me.PKeyControlName with the name of the control on the first form that has
the PKey as its data source.
The above will tell the second form to open showing the record that has the
same PKey as the record selected on the first form.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
TKM said:
When a customer is on a certain record I would like to be able to view
certain informtion from the first form onto the second form. How do I keep
them equal. I am only getting the first recod.