Subform problem

[cbialzik]

I have a form set up with 3 drop down boxes. From the first box the user selects from a category of patient types. The next box then lists patient names based on their selection in the first box. The last box lists the patients visit dates based on the patient they picked. I now need to add several subforms to this form containing patient information based on the visit date chosen. How do I get the subform to only show information based on the selected visit date? Let me know if I need to provide more information.
Thanks!

 

[cbialzik]

Anybody? Any ideas are appreciated.

 

[rborob]

how about
1. having a text box store the ID of the date field
2. write a filter query and use that as the row source for the subform
3. Have the criteria for the subform only show the values where the ID's are equal?