Any reason why a checkbox won't allow a check to be made??

Hi...I have a backend (SQL server) for my database
tables...and Access 2000 for my frontend...I removed a
checkbox from a form...because I added that checkbox
field to a different table...when I added a new checkbox
and linked it to the new field name...it won't
check...some little weird grey box appears inside the
checkbox...and the field doesn't update...I can change
the value from 0 to -1 in the table but it still doesn't
check off on the form...

Too weird...any ideas...I'm all out of them!!!

Hi Jacqueline

I would try removing the present checkbox from the form, then do a
Repair/Compact and then reinsert the checkbox.

Maurice

Hi...I have a backend (SQL server) for my database
tables...and Access 2000 for my frontend...I removed a
checkbox from a form...because I added that checkbox
field to a different table...when I added a new checkbox
and linked it to the new field name...it won't
check...some little weird grey box appears inside the
checkbox...and the field doesn't update...I can change
the value from 0 to -1 in the table but it still doesn't
check off on the form...

Too weird...any ideas...I'm all out of them!!!

Is the form based on the table or a query? If a table, the field is no
longer in that table, as you mentioned. If a query, has the table that now
has the field been added to the query and that field added to the query's
output? If so, can you edit the field directly in the query?

--
Wayne Morgan
MS Access MVP


"Jacqueline" wrote in message
...
Hi...I have a backend (SQL server) for my database
tables...and Access 2000 for my frontend...I removed a
checkbox from a form...because I added that checkbox
field to a different table...when I added a new checkbox
and linked it to the new field name...it won't
check...some little weird grey box appears inside the
checkbox...and the field doesn't update...I can change
the value from 0 to -1 in the table but it still doesn't
check off on the form...

Too weird...any ideas...I'm all out of them!!!

Be aware that if you are using SQL Server linked tables through ODBC any
changes you make to the tables you will have to delet and relink the table
before the changes are reflected in Access.

Ragnar