Checkboxes in Access

B

Backwards Man

How do you have a checkbox remain the same in each record in form view rather
than every record having the same box checked or unchecked??
 
J

John Vinson

How do you have a checkbox remain the same in each record in form view rather
than every record having the same box checked or unchecked??
Click to expand...

Well, you DON'T, not in a properly normalized table!

Data is not stored in forms. It's stored in tables; and in a table,
each field should depend on that record's primary key, only - not on
which other records it's grouped with.

Perhaps this field should be in another table, on the "one" side of a
one to many relationship with this table.

John W. Vinson[MVP]
 
D

Dirk Goldgar

Backwards Man said:
How do you have a checkbox remain the same in each record in form
view rather than every record having the same box checked or
unchecked??
Click to expand...

I'm not sure I follow you. Are you talking about an unbound or
calculated check box -- that is, one that is not bound to a specific
field in the form's recordsource?
 
Top