UtterAccess Discussion Forums > Check yes/no programmatically?

Full Version: Check yes/no programmatically?

UtterAccess Discussion Forums > Microsoft® Access > Access Tables + Relationships

jabez

Feb 7 2006, 03:19 PM

Is it possible to check a Yes/No box in a table programmatically?

I tried:

If X then
Tables!MyTableName!CheckBoxName = True
End if

...but this does not work.

Thanks for your help.

J

freakazeud

Feb 7 2006, 03:22 PM

You could just run an update query or update statement which sets the field from FALSE to TRUE.
HTH
Good luck

cheekybuddha

Feb 7 2006, 03:27 PM

CODE

    Dim strSQL As String

    strSQL = "Update MyTableName Set CheckBoxName = True Where PKField = " & Me.txtPK & ";"
    If X Then CurrentDb.Execute strSQL

hth,

d

Ah! Freakazeud beat me to it!

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.