Jump to content

Check box in Tabular Form ?


Recommended Posts

Posted

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


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...