Bound checkboxes and how to untie it and yet keep it bound

E

EvanSB

Access newbie here. I couldn't find the answer floating around, so I'm trying
it here - I'm working on a database of contact info with two subforms -
Events and Requests info. I've got the contacts all set and the Events all
set, before I tackle Requests. I have a checkbox ("Tax Letter Sent?") that I
bound to the Event_ID for it changes for every person and every event that
person is involved in. It works - except that when I check the box, the
Event_ID field goes to a "-1" category from something like "Welcome Home
Dinner". When I change the Event_ID back to said event, the checkbox unchecks
itself. How can I solve this? Thanks!
 
S

Sprinks

Evan,

If a checkbox, or any other control, is Bound to a field, then whatever data
is entered into the control is saved to the field to which it is Bound. When
you check the box, the value for True, which is -1, is saved to the field.
Since any value other than -1 is considered False, when you change the value
in your combo box, which is also Bound to the Event_ID field, it shows a
value of False in the checkbox.

If you need a status field for your record, add a new Yes/No type field to
the underlying table.

Sprinks
 
Top