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" <(E-Mail Removed)> wrote in message
news:028b01c35ab1$7dd777d0$(E-Mail Removed)...
> 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.

Thanks for the help. I am going to try to insert a field
in the table first...
>-----Original Message-----
>"Sarah" <(E-Mail Removed)> wrote in message
>news:028b01c35ab1$7dd777d0$(E-Mail Removed)...
>> 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.
>
>
>.
>

"Sarah" <(E-Mail Removed)> wrote in message
news:035b01c35aba$bfd65ee0$(E-Mail Removed)...
> 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?