Where is the problem in this simple form

[Mixer1]

I have a table with 5 fields. One of those is a Yes/No Field. This is my
problem field

I can open the table fine and see the Check box and check/uncheck the
records just fine.

I have a query that is also based on this table. I can open the query and
check/uncheck this yes/no field just fine as well.

I have a simple form that pops up and is based on the above query. All of
the fields on this form were dragged from the Field List Button containing
available fields from the query.

But the check box field is greyed out when I go to Form View . . . and if I
try to check on this record, I am told that "Control can't be edited; it's
bound to unknown field 'Admin S'. But admin S is the name of the table field
and also the query field. What am I missing??

 

[mscertified]

It's best not to use embedded blanks in column names. When referring to it,
always use [Admin S]

 

[Jeff Boyce]

You don't mention where the data is being stored.

I ran into a similar problem with data being stored in SQL-Server. It turns
out there is a "strange, but inexplicable" interaction between a "bit"
(Yes/No) field in a SQL-Server table and the absence of a SQL-Server
"Timestamp" field (this is a misnomer -- it is actually a field SQL-Server
uses to see if a record has been grabbed for edit).

I resolve the issue I was seeing by adding a new field to the underlying
SQL-Server table, and designating it as a "Timestamp" data type field.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mixer1]

Its an Access Front End Back End relationship. Back End is another Access 03
that only has Tables. There is a general password on the BE that is stored

 

[Mixer1]

On the Form, I replaced Admin S with [Admin S] and I get the same thing.

BTWm I would never use spaces like this. Most of these databases have been
inherited. They do some amazingly complex things (By my humble understanding)
but they don't follow anything normal in the way of standards.

But I was told by one of the users that this worked fine and in just stopped
working. I went back to several iterations of changes and I can say
absolutely that nothing was changed on the "production" front end. So I
assume it was always broken . . . . .

It's best not to use embedded blanks in column names. When referring to it,
always use [Admin S]

I have a table with 5 fields. One of those is a Yes/No Field. This is my
problem field

I can open the table fine and see the Check box and check/uncheck the
records just fine.

I have a query that is also based on this table. I can open the query and
check/uncheck this yes/no field just fine as well.

I have a simple form that pops up and is based on the above query. All of
the fields on this form were dragged from the Field List Button containing
available fields from the query.

But the check box field is greyed out when I go to Form View . . . and if I
try to check on this record, I am told that "Control can't be edited; it's
bound to unknown field 'Admin S'. But admin S is the name of the table field
and also the query field. What am I missing??