Checkboxes in forms

[Sarah]

I recently designed a form that pulls information from a
previously created query in a database. The form
functions just as I want it with one exception...the check
boxes.

If I exit the design form and try using the form to input
information, or more simply place a check in a checkbox in
one record, all the records checkboxes are then checked?
Id there any way to adjust this so that only the record I
am working in records this?

I would appreciate any advice.

Thanks

 

[Rick Brandt]

I recently designed a form that pulls information from a
previously created query in a database. The form
functions just as I want it with one exception...the check
boxes.

If I exit the design form and try using the form to input
information, or more simply place a check in a checkbox in
one record, all the records checkboxes are then checked?
Id there any way to adjust this so that only the record I
am working in records this?

Sounds like the checkbox is not bound to a field in the query.

 

[Guest]

Thanks for the help. I am going to try to insert a field
in the table first...

 

[Rick Brandt]

I have linked it to a field in the query...and now if I
check the box in the table it's all set...but why can't I
do this in the form?

Where is the query getting this field? From a table or from an expression? The
latter won't work. If you are using the former then do you have this field in the
query set as the ControlSource of the CheckBox on the form?