Checkbox control source problem

[jack1080]

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?

 

[PHV]

Perhaps this instead ?
chk.Value = DLookUp("ischecked", "tbluser", "userId='abc'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jack1080]

Thanks, but I need the value to be updated to the database.
If the user checked the checkbox update yes, else no.

 

[lespaul]

updated to the database

Then use an UPDATE query instead of a SELECT query?

Dim sSQL as string
sSQL = "Update tblUser Set [ischecked] = [ControlOnForm?] where userId='abc'"

Additionally, do you really want the userId hardcoded or do you need to get that from the control on the form too?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[jack1080]

Hi lespaul,

Do you mean to bind the following sql to control source?
sSQL = "Update tblUser Set [ischecked] = [ControlOnForm?] where userId='abc'"

>>
do you really want the userId hardcoded or do you need to get that from the control on the form too?
<<
ans: need to get that from the control on the form