How update field in a table based on seletion in combobox
Posted on 2013-06-12
I have this afterupdate event on a checkbox on a form. It is an unbound form.
Private Sub chkbxReturned_AfterUpdate()
Dim RS As DAO.Recordset
Set RS = CurrentDb.OpenRecordset("tblImportRecords")
RS!Returned = Me.chkboxReturned
But I don't know how to get code in here to tell it which record to update. The selected record is in the combobox named cboReturned and the key field is ID in the table tblImportRecords.