continuous form

[tim h]

I have a continuous form listing hospital names.
I want to be able to click on the hospital name and bring
up the pop-up "input" form which has Hospital details.
Which macro do I use to make sure the corresponding
details are shown in the pop up form.

Thanks in advance,
Tim h

 

[tina]

use the OpenForm macro action. in the Action Arguments
list at the bottom of the macro window, add an expression
to the Where Condition, as

[HospitalName] = [Forms]![ContinuousForm]![HospitalName]

the first instance of HospitalName refers to the
appropriate field in the detail form's underlying query.
substitute the correct form and field names, of course.
and if the hospital name field is not the primary
key/foreign key for your two related tables, then use the
key fields instead.

hth