Check Boxes

[roadie.girl]

I know this is an idiotic question ...

I'm trying to bind a check box to my table.
In the table, I have it as a "yes/no" field with a text field as a
lookup and no format assigned to it.

On the form, I have a checkbox, with the data sources as "UserField12".

Any tips/links I can use to make whenever I click on the check box it
automatically changes userField12 to the right value (right now if i
click on the box, nothing happens).

Thanks so much in advance!!!

 

[Guest]

In the table, I have it as a "yes/no" field with a text field as a lookup
and no format assigned to it.
I do not understand how a Yes/No field can have a text field as a lookup.

A Yes/No field stores data as a minus one ( -1) or a zero ( 0 ).

A checkbox has one of three states --
Unchecked - Gray
Checked - Check mark
Unchecked - White

 

[Guest]

Unless I'm mistaken, what I think you have done is generate a tick box in
table design view with yes/no attributes and where the lookup tab is at the
bottom of the design view table screen, you have selected from there, a text
box from the drop down list. This should in fact be left as a check box.

with your form in design view, select show field list from the view menu,
drag the newly created text box to your form and you should have a little box
with a label which allows you to tick or un tick it when the form is back in
general view. Ticked = -1 un-ticked = 0

I hope this helps but I may have misunderstood your description of what you
have done as well?????