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

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

Jacqueline

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