Form works! Now, user selects from combo & adds record want next choice in combo box to appear

[GinaFlan]

My Form works !!!!




Each user/department has a list of goals. After they highlight their first goal and "Add" the record cmdADD I would like for their next goal to appear in the combo box automatically. What word would I use to search with for this code to make this happen? Would it be "next"

The combo box is populated by a table.

[llkhoutx]

USE ADO or DAO to find the current value in the combo box row source, move to the next record, save that value in the combo box and call all the combo box AfterUpdate event.

[GinaFlan]

Ok great thank you