May 29, 2003 #1 BigFizil MIS Mar 9, 2003 23 US trying to set something up so when the user is done searching for one item they dontt have to go and manually clear out out each box
trying to set something up so when the user is done searching for one item they dontt have to go and manually clear out out each box
May 29, 2003 #2 159159 Programmer May 29, 2003 10 GB hey why not set up another command button, and in thier do the following On Error GoTo Err_Save_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToRecord , , acNewRec Exit_Save_Click: Exit Sub basically this will clear the combo-box for the next item Upvote 0 Downvote
hey why not set up another command button, and in thier do the following On Error GoTo Err_Save_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToRecord , , acNewRec Exit_Save_Click: Exit Sub basically this will clear the combo-box for the next item