Please Help: Add a new record to the combo box and prompt to that record

[elainenguyen]

I have a form call frmMedRec and on this form, I have a cbo box call Patient, then next to the cbo patient, I have a command button "Add a new patient". When the user click on this Add a New Patient Button, it opens a oop up form Add A new Patient, When the user click Save button on the Add a new Patient form, it closes the Add a new patient pop up form, and it adds this new patient to the cbo Patient box. However, the user has to re-select this new patient again, because the cbo box didn't prompt right at the new patient.
Any idea? I really appreciate everyone's help. Thanks!

Here is my code under the Save Button on the Pop Up form "Add a new patient":

Private Sub cmdSave_Click()
If IsNull(txtPT_MRN) Then
        MsgBox "Patient MRN is required!", vbInformation, "REQUIRED FIELD!"
        [txtPT_MRN].SetFocus
ElseIf IsNull(txtPT_Name) Then
        MsgBox "Patient Name required!", vbInformation, "REQUIRED FIELD!"
        [txtPT_Name].SetFocus
 
Else
    MsgBox "Patient: " & [txtPT_MRN] & " " & [txtPT_Name] & " has been   added successfully!", vbInformation, "Patient has been added!"
    DoCmd.Close acForm, "fdlgAddPatient", acSaveYes
    [Forms]![frmMedRec]![cboMRN].SetFocus
    [Forms]![frmMedRec]![cboMRN].Requery
 
End If
 
Exit Sub
End Sub

[Rabbit]

So basically you want the combobox to be at the new patient after they add it through the form?

BEFORE the form closes, requery the combobox and set it's value to the new patient.

[Forms]![frmMedRec]![cboMRN] = Me.PatientName

[elainenguyen]

Thanks Rabit, It worked. You are such a big help!
Elaine

[Rabbit]

Not a problem. Good luck.