Checkbox not staying checked

M

Meridian

I have been searching and searching, but I am able to find the answer I need.
I created a checkbox in Access and when I go back to the form view I can
check the box, save the database, but when I close out and go back in the
checkbox is not selected. This also happens if I check the box, go into the
design view, and back to form view. Is there a setting that needs to be
updated, or how to enable the checkbox to stay selected? Thanks so much!
 
J

Jeff Boyce

Meridian

Any change that check box is not bound to an underlying field?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Meridian

Hi Jeff,

I don't think that it is. I created the checkbox by selecting the Toolbox
icon, and then selecting the checkbox symbol placing it in the form. I am not
sure if maybe I need some type of change in the properties or what update I
need to make.

Meridian
 
J

Jeff Boyce

And my post should have read "any CHANCE that check box..."!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Meridian

Hi Jeff,

I don't think that it is. I created the checkbox by selecting the Toolbox
icon, and then selecting the checkbox symbol placing it in the form. I am not
sure if maybe I need some type of change in the properties or what update I
need to make.

Meridian
 
J

John W. Vinson

I have been searching and searching, but I am able to find the answer I need.
I created a checkbox in Access and when I go back to the form view I can
check the box, save the database, but when I close out and go back in the
checkbox is not selected. This also happens if I check the box, go into the
design view, and back to form view. Is there a setting that needs to be
updated, or how to enable the checkbox to stay selected? Thanks so much!
Click to expand...

A Form is JUST A WINDOW. Checkboxes, textboxes, etc. are just controls; they
do NOT store any information.

Information is stored in a Table. A Checkbox control can be bound to a Yes/No
field in a table, by setting its Control Source property to the name of that
field; this will let you store multiple records, some checked yes, some
checked no.

If that's not what you're trying to accomplish, please explain.

John W. Vinson [MVP]
 
J

Jeff Boyce

Meridian

Open the form in design view. Click on the checkbox. Click on the
Properties button. What does it say the source is? (my hunch is that there
is none ... so the check you make isn't being saved in any table.)

If there isn't a source, use the drop-down arrow to select a field (your
yes/no field?) to bind the checkbox to.

(see John's response, too)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top