RowSource Property?

Hi

I have a form that is populated by the user making a selection from a combo box with the RowSource based on a query. Once the record is retrieved the user can make changes to data and save any changes to a table. It is not a straightforward data entry form, the controls are filled by a stored procedure and when a Confirm button is clicked another procedure runs to make some calculations which are subsequently saved.

Occasionally it is necessary to update all records so I need some code that retrieves each record in turn from the combo box and then runs the Confirm click event.

How can I do this? Maybe a Do...Loop that can select from the combo box?

Many thanks for any assistance.

Mike Collard

If I understand you correctly, you are want to update every record that shows up in the combobox instead of selecting one and doing it one at a time.

Create another confimAll button and run your same code against the information in the combo box

s= "Select * from ComboBoxQuery"
Set db = currentDB
Set rs = db.OpenRecordset(s)

DO while Not rs.EOF

****Code***

Call cmdConfirm_Click 'confirm button Code Call

rs.movenext
Loop

I am looking to do the same functions that are quoted above, but I have not been able to get it working correctly. Could you post how you managed to do it, or the related code you used?

Thanks to S.Baxter - solution looks good - will try it out tomorrow.


Mike Collard