Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't read control on subform

Status
Not open for further replies.

armada

Technical User
Aug 27, 2001
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top