Combo box selection to query automate

[SuperDuperNuker]

I have a combo box filled with the results of a simple selection query. Right now I highlight the selection and then send it to an update query. Everything works fine, but I need a method to process each option automatically but individually (one at a time) and send it to the update query so I don't have to click on each option one at a time. I also need it to log the fact that it processed the selection to a transaction table. Example: Combo box has batch numbers, 1,2,50,221. I currently highlight each option and then send that selection to update query via a command button. The update query processes the selection and returns the fact that the query is completed via a msgbox. I don't need the msgbox and would like to instead log the fact to a table. Please help!

 

[PHV]

I don't need the msgbox
Have a look at the DoCmd.SetWarnings method

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SuperDuperNuker]

I know how to disable the msgbox confirmation...not worried about that. It is how to automate submitting the combo box items individually to an update query....