update table with unbound checkbox (1 Viewer)

[bbwolff]

very basic question
how do you update table with unbound checkbox?
I'd like to add basic yes/no, true/false on update.
currently I'm using a workaround like this

If Me.chkInkt = True Then
        status = "true"
        Else
        status = "false"
    End If

which is ok if there's one of these, but sometimes i have more

 

[CJ_London]

why not just bind the control to the field?

Also if status is a yes/no field then you should use

Status=True (no quotes)

And in fact you don't need the if clause

Status=chkInkt

is quite sufficient

 

[bbwolff]

like this?

DoCmd.RunSQL "UPDATE Table  SET aesm = me.chkEsm WHERE ID = " & tID

 

[CJ_London]

no, like this

DoCmd.RunSQL "UPDATE Table SET aesm = " & me.chkEsm & " WHERE ID = " & tID