For the following code chk is a check box, ischecked is a yes/no field.
Dim sSQL as string
sSQL = "Select [ischecked] from tbluser where userId='abc'"
chk.ControlSource = sSQL
chk.Requery
But when I run the following vba code, no matter ischecked is yes or no, it always shows me the checkbox is unchecked. Am I doing anything wrong? If yes how to correct it?
Dim sSQL as string
sSQL = "Select [ischecked] from tbluser where userId='abc'"
chk.ControlSource = sSQL
chk.Requery
But when I run the following vba code, no matter ischecked is yes or no, it always shows me the checkbox is unchecked. Am I doing anything wrong? If yes how to correct it?