Thanks Neil! I'm getting a "Compile Error" "Method or data member not found". Where in the code below should I put it? Sorry I'm not that familiar with VBA.
TIA, Izzy >>> "Squires, Neil" <[EMAIL PROTECTED]> 6/15/2007 12:40 PM >>> Add this to the command button code. me.cboPickList.requery That should do it. Neil Squires _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Isaiah Vi Sent: Friday, June 15, 2007 11:10 AM To: [email protected]; [EMAIL PROTECTED] Subject: [ms_access] Save Command Button on Form 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] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
