Check boxes

[smeldawg]

I have check boxes on a form. When I check a box, save the form, close the
form and then re-open the check is not present anymore. Also, when i check a
box and then go to a new record, the checks follow. If I edit the check on
the new record, they are edited on the previour record. How do I prevent
these issues?

Thanks

 

[BruceM]

It sounds as if you have an unbound check box. You need to bind it to a
yes/no field. It could be another field type in some cases, but the point
is that it needs to be bound to a field in order for the value to be saved.
To see this property, open the form in Design view, click the check box to
select it, click View >> Properties, click the Data tab, and look at the
Control Source line.

 

[smeldawg]

That has worked to tie the checks to the appropriate form, but now the yes/no
fields that I binded it to are being changed to a -1 or 0 once the box is
checked. how do I change that?

Thanks

 

[BruceM]

Open the table in design view. Click the field in question. Is its Data
Type listed as Yes/No? If so, at the bottom left of the window click the
Format tab, and change Display Control to Check Box.
If the Format on the General tab is blank and the Display Control is a text
box, a Yes/No field will display as -1 or 0. If the Format is set to Yes/No
and the Display Control is a text box the field will be displayed as Yes or
No. Same idea for True/False and On/Off. However, if the Display Control
is a check box then the Format does not affect the display.
Access stores the information as 0 or -1, so it shouldn't matter how it is
displayed in the table, except for the developer's convenience or
preference. Users shouldn't see the table in any case.