Hi,
I have a main form (Patient details) with a subform(RelationXF--record source is a juntion table).
When I choose to enter a new patient, I enter all of the fields. The last field is Zip Code. When I enter the zip and hit tab I am in the first field of my subform.
I have RelationXID, and PatientID. PatientID is a combobox so the user can select a name.
The problem is when I tab from PatientT.Zip to the subform, PatientID does not show the new patient name I just entered!!!! How/where do I go about refreshing the underlying PatientT/PatientQ (i've tried both) so the name is visible???
Do I use Me.Refresh, Forms!PatientT.Refresh, and where do I put it? I tried the OnLostFocus event for the PatientT, Ziptxt, and anywhere I could think of.
Please, your help would be appreciated.
Thanks,
Don