Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trying to clear combo boxes on search form

Status
Not open for further replies.

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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top