Private Sub Combobox_AfterUpdate()
DoCmd.RunCommand (acCmdSaveRecord)
End Sub
'OR
Private Sub Form_AfterUpdate()
DoCmd.RunCommand (acCmdSaveRecord)
End Sub
Each time the user changes the combobox value I need to refresh the entire datasheet (usually not more than 30 rows) for this new value and for any matching row.that sounds like you want to save the new data right then and there (use the control's Afterupdate() event), right? Also, what did you mean by "and for any matching row"?
If the user changes a combobox I will display the same value in a few other rowsThis is as clear as mud. Why does updating one record cause other records to change? If what you are saying is that when a user adds a new value to the combo's RowSource, you want it ti be available in all rows immediately, then in the GotFocus event of the combo, use:
Where is the update being made? A little more design detail, please. The right answer depends on it.