Check Box Not Saving

[chablups]

I just spent all day redesigning a form and putting in check boxes from the tool box, but when I saved the whole thing and tested it by clicking in the check boxes to put the check marks in the boxes and then clicked save, it did not save the check marks! AARGH! When I went back to the form all the check boxes were empty. Why won't it save the check marks? Please help. Thanks.

 

[Tarantula]

you have to be more specific, or in order to help you out you have to put some code on this forum.

 

[chablups]

Thanks for your reply, I'll try to be more specific

I am not using any code. It's really very simple what I'm doing. I have a form and there are various documents that have to be checked in on the form, so, I went in to design and then clicked on the tool box. I then clicked on the icon in the tool box to place a check box on my form. I saved the form. I then tried to use the form by clicking on the check box and putting a check mark in it. Then I saved the form. But when I open the form back up the check mark is no longer there, it did not get saved. The check marks don't get saved, so the whole thing is of no use if it doesn't save the check marks. Thanks.

 

[ShaneMan]

Hey chablups,

Your check boxes, that you used from the toolbox, are unbound, so when you close the form they do not hold a value. You need to go into your table and create Yes/No fields for each check box. Then go back into your form and assign each check box the appropiate Yes/No field name. Use the control source in your check boxes properties window to do this.

HTH,
Shane

 

[chablups]

Thanks ShaneMan, but one little problem

Thanks for the fast reply Shane - The problem is I have no Control Source in my check box properties because I never had the fields in my Table to start with. I just clicked on the form in Design View and named the labels whatever I wanted. I figured it was a little bit of a shortcut since I didn't have to put things in my table first. Then to my horror after spending all day designing the form, I discovered they wouldn't save. So now it looks like I will have to start from scratch by entering the fields in my table first and then assigning them to my check boxes in Form Design View. Thanks again.

 

[Oldsoftboss]

See my reply in your other post,

Dave

 

[chablups]

One other question SoftBoss

The little check boxes, where the check marks are put, are by default, grayed out. Is there any way to make that default just plain white when there is no check in the box? Thanks, loved your "bumpy road" too.

Chablups

 

[RV]

Is there any way to make that default just plain white when there is no check in the box?

Yup, either set a default on table column level or on control field level in your form.

RV

 

[ScottGem]

Thanks for the fast reply Shane - The problem is I have no Control Source in my check box properties because I never had the fields in my Table to start with. I just clicked on the form in Design View and named the labels whatever I wanted. I figured it was a little bit of a shortcut since I didn't have to put things in my table first. Then to my horror after spending all day designing the form, I discovered they wouldn't save. So now it looks like I will have to start from scratch by entering the fields in my table first and then assigning them to my check boxes in Form Design View. Thanks again.

Unbound controls will not save there values from record to record or when the form is closed. that's just the nature of unbound controls. When you have a lot of checkboxes, that can indicate a problem with your table design. Can you give us more info about the table and what the checkboxes represent? We may be able to give you some alternatives.

 

[Oldsoftboss]

The little check boxes, where the check marks are put, are by default, grayed out. Is there any way to make that default just plain white when there is no check in the box? Thanks, loved your "bumpy road" too.

Chablups

This is because they have no value (Null). Once you set up your tables, set the default value to No.

Dont worry too much about the forms yet. Make sure you set up the tables correctly first.

To use an analogy, you are making sure the paint job is right before you have bought the car.

Dave

 

[chablups]

Thanks Dave.

That worked great!