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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem retrieving data with multiple subforms

Status
Not open for further replies.
Feb 6, 2003
22
US
I have a Master Form, a Subform1, and a Subform2 that is contained by Subform1. Subform2 is called CompletedBy. CompletedBy consists of an id, an empid, and the serviceticketid which links it to Subform1.

I use a combo box to retrieve emp first and last name so users can select the name and then I pop the corresponding empid into the form field. The form and subforms work fine to enter data BUT when I navigate and then go back or even when I close and re-open the form - sometimes the data does not appear.

It is in the CompletedBy table but the form does not retrieve it. Any ideas?? Is this because I am using multiple subforms? Because Subform1 works just fine on its own.

Thank You...Michelle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top