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!

Sorry, my post should have stated that I am unable to find the answer....

"Meridian" wrote:

> 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!

Meridian

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Meridian" <(E-Mail Removed)> wrote in message
news:FB226EA4-9B34-4E4B-85D5-(E-Mail Removed)...
>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!

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

"Jeff Boyce" wrote:

> Meridian
>
> Any change that check box is not bound to an underlying field?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Meridian" <(E-Mail Removed)> wrote in message
> news:FB226EA4-9B34-4E4B-85D5-(E-Mail Removed)...
> >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!
>
>
>

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jeff Boyce" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Meridian
>
> Any change that check box is not bound to an underlying field?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Meridian" <(E-Mail Removed)> wrote in message
> news:FB226EA4-9B34-4E4B-85D5-(E-Mail Removed)...
>>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!
>
>

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

"Jeff Boyce" wrote:

> And my post should have read "any CHANCE that check box..."!
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Jeff Boyce" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Meridian
> >
> > Any change that check box is not bound to an underlying field?
> >
> > Regards
> >
> > Jeff Boyce
> > Microsoft Office/Access MVP
> >
> > "Meridian" <(E-Mail Removed)> wrote in message
> > news:FB226EA4-9B34-4E4B-85D5-(E-Mail Removed)...
> >>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!
> >
> >
>
>
>

On Mon, 9 Jul 2007 11:52:02 -0700, Meridian
<(E-Mail Removed)> wrote:

>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!

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]

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

"Meridian" <(E-Mail Removed)> wrote in message
news:C81F5FC2-7580-4C50-9430-(E-Mail Removed)...
>
> 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
>
> "Jeff Boyce" wrote:
>
>> And my post should have read "any CHANCE that check box..."!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Jeff Boyce" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > Meridian
>> >
>> > Any change that check box is not bound to an underlying field?
>> >
>> > Regards
>> >
>> > Jeff Boyce
>> > Microsoft Office/Access MVP
>> >
>> > "Meridian" <(E-Mail Removed)> wrote in message
>> > news:FB226EA4-9B34-4E4B-85D5-(E-Mail Removed)...
>> >>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!
>> >
>> >
>>
>>
>>