Checkbox Validation

[AlPhilps]

Hi

I'm fairly new to this Access lark and having problems getting to grips with some of the simple stuff (stuff I could easily do in ORACLE Forms etc...)

Anyone care to tell me how to make checkboxes work in Forms?
i.e. if I base it on a table Y/N column, how do I make the on/off functionality reflect Y/N in the table?

Please bear in mind when answering that I'm using v2, if that makes any difference...

Cheers
Al

 

[jebry]

Hi!

What you need to do is set the control source of the check box to the field from your table. Of course the form's recordsource must include that field. To find the record source of the form and the control source of the control, you need to open their respective property sheets by right clicking and choosing property and click on the data tab. To select the form click on the box in the upper left where the horizontal and vertical rulers meet.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[AlPhilps]

Ta, but what I need to know is which part of the property sheet needs to be modded so that a checked checkbox becomes a "Y" in my table and unchecked becomes an "N". Do I need to set up some triggers??

 

[AlPhilps]

Anyone?

This is easy surely? Help me out here.........