I hav a little bit of confusion about Access Database. I have created a database contains a single table (consists of five fields)
A Tabular Form has been created using Form Wizard. The table having two "Yes/No" data type that can contain only n only 0 and 1. Now the form is in tabular form... I have coded some VB code for manipulation of data. I want to set Uncheck all check boxes at startup, I mean...What should I code in Form_Load() function.
I have tried this
S1.Value=0 S2.value=0
It unchecks upper first checkboxes only. Rest of grid having same state and doesn't change.
But I have also used this code to disable these checkboxes and whole grid of checkboxex can be disabled.
S1.Enabled=0 S2.Enabled=0
If Its not possible using VB code...Please give any UPDATE query that SET S1 and S2 to zero via calling some function name like UpdateCheckBox()
Help Me Please !!!
http://www.sendspace.com/file/rmf128
Here is the sample access database file



Help

Back to top








