Hi friends.
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

Vishal Gupta wrote Sorry buddy but I have no idea about it otherwise I'll be delighted to help you. May be some one else can help you?

Thanx Vishal for reply ! I have posted this in MSDN Forum since 2 day before....But its so sad nobody....reply

piyush wrote This is just a logic but i can try this s1.value=0 if(s1.value=0) s2.value=0

It unchecks upper row only.....complete form can't be unchecked.