[ms_access] Save Command Button on Form

[Isaiah Vi]

Group,
I have a "Save Record" command button on my form.  When I click it to save the 
file it does not add the record I just entered.  However, when I close the form 
and open it again the record shows up.  My goal is have the record I just 
entered show up on a pick list (combo box) immediately after I click the "Save 
Record" button.  This is the code behind my Save Record button:
 
Private Sub Command18_Click()
On Error GoTo Err_Command18_Click
 

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
 
Exit_Command18_Click:
    Exit Sub
 
Err_Command18_Click:
    MsgBox Err.Description
    Resume Exit_Command18_Click
    
End Sub
 
Any help is appreciated!
 
~Izzy


[Non-text portions of this message have been removed]