subform to show previous visit dates

[Vickie English via AccessMonster.com]

Hello,

I have a form called DailyActivities with field names including patID,
patName, visitDate, TotalON, etc. Patients may have several different
visitDates but each time they visit they have the same patID and some other
(different) information(all on the DailyActivities form).

I'm trying to pull all visits for a particular patient together most likely
on a separate form called previous Visits (I guess this form will have a
subform on it showing all the visits). My DailyActivities form will have a
command button to call the previous visits form

When I select a date on the subform I'd like the visitDate's information to
show.

I created the form with the subform but unfortunately it shows visits from
other patients. Could someone please give me some ideas. I know there's a
lot in here so please let me know if you need any further clarification.
Any help will be greatly appreciated. Thanks.

VE

 

[Wayne Morgan]

You need to have the patID field in both forms. Next, with the main form in
Design View, open the Properties sheet and click on the subform ONE time.
This will give you the properties of the subform control. This control is a
control on the main form and is a container control for the subform. The
subform is not "directly" on the main form. On the Data tab of the
Properties for the subform control there will be boxes for Master and Child
link fields. Set these to the patID field. This will link the subform to the
main form on that field so that the subform only shows records where the
patID field matches.