make visable

[Guest]

I have a form with two subforms
One is a contiuous form
and the other is a single form
the continous form has 2 fields Full Name and ID
When I click on ID I want the single form to be visiable with the
coresponding ID.
So if I click on ID 1 then the form show me the single form with ID one. I
pretty sure I have to do a where condition somewhere.
Thanks
Chey

 

[Steve Schapel]

Chey,

Here's one way...

On the main form, put an unbound textbox. In the Control Source, make a
reference to the ID field on the continuous view subform, the equivalen
of this...
=[NameOfContinuousSubform]![ID]
Let's say you name this textbox IDRef.
Ok, go to the properties of the single subform, and set the Link Child
Fields property to [ID], and the Link Master Fields property to the name
of the textbox [IDRef].

You will probalby want to set the Visible property of IDRef to No.