Checkboxes in forms

  • Thread starter Thread starter Sarah
  • Start date Start date
S

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
 
Sarah said:
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?
Click to expand...

Sounds like the checkbox is not bound to a field in the query.
 
Sarah said:
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?
Click to expand...

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?
 
Back
Top