Refreshing a subform?

[Shag84]

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

[Access_Blaster]

Open your subforms properties in design view, look under the "events" tab select after update. Click the three ... and choose code builder, then type me.requery or try me.refresh.

[Shag84]

Sadly, this doesn't work. But I appreciate your replying.
Any other thoughts?

Thanks,
Don

[orange]

This may help
http://www.techonthenet.com/access/subforms/refresh.php

[Shag84]

I apologize for my delay in responding.
I appreciate the link, but I found that one the other day and it does not work.

My problem isn't linking to an existing set of data. I want to enter a new child on program, enter his parents name, then populate the juction table to create the relationships. Without the user have to do redundant work.

Thanks again. Please let me know if you have any other ideas.
Don