I have a form that has a combo box that after update generates a sql that grabs the matching record in a table and returns its fields. All the textboxes are correctly populated but the check boxes are not checked on the form but are checked from the table they sql string was pulled from.
Code:
varOwnerID = cboOwnerName.Column(0)
strSQL = "SELECT Owner.* FROM Owner WHERE [Owner.OwnerID]= " & varOwnerID
Set rs = dbs.OpenRecordset(strSQL)
txtOwnerName = rs!OwnerName
txtAddress = rs!Address
chkActive = rs!Active
chkReview = rs!Review
txtOwnerComments = rs!OwnerComments
rs.Close
Set rs = Nothing
How can I modify my script to populate the check boxes with the correct value?
Many thanks.