Hi. New to forum posting; apologies in advance for providing insufficient info.
I have a form ([Attendance Tracking]) with a subform ([Name Lookup]). When designing the subform [Name Lookup], I placed two subforms in it's form footer ([DogLookup] and [OwnerLookup]). These are used in combination with text boxes in the FormFooter to "lookup" a field from the subforms in the footer and then link them back to text boxes in the Main form. All Master/Child relationships are established.
The common field for OwnerLookup is Client ID, and the common field for DogLookup is DogID. The subform loads data properly for the Client ID field and populates all fields with the appropriate ClientIDs. However, the other fields in the form show the information associated with the first Client ID, UNTIL I click on the other records, at which point the other fields populate with the info associate with the displayed client ID.
Included Fields: Client ID, Owner1, Owner2, Dog ID, Dog Name
(for all records the right Client ID shows up, but until I click on a field in the 2nd, 3rd, etc. records, the other fields ALL show the info for the first Client ID; once I click on any field in the other records, the other fields repopulate with the right info).
I'm better with macros than I am with code writing but, regardless of the solution, am looking for a way to get all fields for all records to populate with the proper information without having to click on a field in each individual record.
Thanks in advance for any help...
I have a form ([Attendance Tracking]) with a subform ([Name Lookup]). When designing the subform [Name Lookup], I placed two subforms in it's form footer ([DogLookup] and [OwnerLookup]). These are used in combination with text boxes in the FormFooter to "lookup" a field from the subforms in the footer and then link them back to text boxes in the Main form. All Master/Child relationships are established.
The common field for OwnerLookup is Client ID, and the common field for DogLookup is DogID. The subform loads data properly for the Client ID field and populates all fields with the appropriate ClientIDs. However, the other fields in the form show the information associated with the first Client ID, UNTIL I click on the other records, at which point the other fields populate with the info associate with the displayed client ID.
Included Fields: Client ID, Owner1, Owner2, Dog ID, Dog Name
(for all records the right Client ID shows up, but until I click on a field in the 2nd, 3rd, etc. records, the other fields ALL show the info for the first Client ID; once I click on any field in the other records, the other fields repopulate with the right info).
I'm better with macros than I am with code writing but, regardless of the solution, am looking for a way to get all fields for all records to populate with the proper information without having to click on a field in each individual record.
Thanks in advance for any help...
