Check yes/no programmatically?
UtterAccess Discussion Forums
Access Tables + Relationships
Feb 7 2006, 03:19 PM
Is it possible to check a Yes/No box in a table programmatically?
If X then
Tables!MyTableName!CheckBoxName = True
...but this does not work.
Thanks for your help.
Feb 7 2006, 03:22 PM
You could just run an update query or update statement which sets the field from FALSE to TRUE.
Feb 7 2006, 03:27 PM
Dim strSQL As String
strSQL = "Update MyTableName Set CheckBoxName = True Where PKField = " & Me.txtPK & ";"
If X Then CurrentDb.Execute strSQL
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