I have a main form with 5 subforms (on tabs) The main form is used for demographic information and the subform in question is used to post a variety of inofrmation related to encounters or visits. The demographics table uses a PID field as the main index, the visits field has the corresponding PID (linked to the main form succesfully!) field plus its own index-RID. The problem is that a client has more than one visit to the shop but when I try to print a visit report based on this filter:Forms![Main_frm]![Visits_sub].Form![RID] = Reports![Visit_rpt]![RID] I get a blank page. I tried using a setvalue macro, same result then I tried running a query with worse results the criteria RID = Forms![Main_frm]![Visits_sub].Form![RID] did not work, however if I type the RID number directly on the criteria field the query returns the right values. Any suggestions?
Thanks
Armada
Any suggestions on how to print one of many records on the subform
Thanks
Armada
Any suggestions on how to print one of many records on the subform