Check Box Not Working

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi!

All of a sudden on a newer version of our application a check box on the
"Produce Invoice" form cannot be checked. I did not do any changes to this
form at all.

Below are the things that I know so far about the problem:
1. On the new version of the application the check box cannot be checked
2. On the previous version of the application the check box can be checked
3. I did not do any changes to the form
4. Using the previous application having the working form, I exported the
objects related to the form to the newer version of the application. But
it still did not solve the problem.

I have no ideas as yet as to the cause. The form is linked to a table,
which is linked to a table in the SQL Server database. I checked the table
and redo the linking of the table object in Access but they did not solve
the problem still.

Any help is appreciated.


Thanks,

Ben
 
Check and make sure that the check box is still bound to the column in the
table. Somewhere it probably became unbound. If it is unbound, it won't work.
 
I checked and it is bound to the table field.


Golfinray said:
Check and make sure that the check box is still bound to the column in the
table. Somewhere it probably became unbound. If it is unbound, it won't
work.
Click to expand...
 
Now make sure the form is editable, that is it has the arrow and asterisk at
the bottom so that you can add records. If you can't add records, your table
is not editable either and you will have to fix that. Also make sure once
again that the yes/no field is there in the table.
 
Hi!

All of a sudden on a newer version of our application a check box on the
"Produce Invoice" form cannot be checked.  I did not do any changes to this
form at all.

Below are the things that I know so far about the problem:
1. On the new version of the application the check box cannot be checked
2. On the previous version of the application the check box can be checked
3. I did not do any changes to the form
4. Using the previous application having the working form, I exported the
objects related to the form to the newer version  of the application.  But
it still did not solve the problem.

I have no ideas as yet as to the cause.  The form is linked to a table,
which is linked to a table in the SQL Server database.  I checked the table
and redo the linking of the table object in Access but they did not solve
the problem still.

Any help is appreciated.

Thanks,

Ben
Click to expand...

if the checkbox is bound to a field in the table, and the field name
has changed, this problem could happen, and with it does, a status bar
message will appear in the bottom left of the access applicatio
something like "control can't be edited, its bound to an unknown
field"

if you open the table in access, can you
a) change the current value of the field for a given record ?
b) create a new record ?
 
Create Invoice form is linked to a pass-through query. The query is
accessing a view in the sql server.

The previous version still works with the same setup as the current version
that I am working on, where I am having a problem. I have tried to set the
enable and lock to true in the oncurrent event but still I cannot click the
check box. There were no changes to the tables that are being referred by
the view object.

The fact is, using the older version, the Create Invoice form works fine.
But, without any changes, in the current version, the Create Invoice does
now allow me to click the checkbox.


Hi!

All of a sudden on a newer version of our application a check box on the
"Produce Invoice" form cannot be checked. I did not do any changes to this
form at all.

Below are the things that I know so far about the problem:
1. On the new version of the application the check box cannot be checked
2. On the previous version of the application the check box can be checked
3. I did not do any changes to the form
4. Using the previous application having the working form, I exported the
objects related to the form to the newer version of the application. But
it still did not solve the problem.

I have no ideas as yet as to the cause. The form is linked to a table,
which is linked to a table in the SQL Server database. I checked the table
and redo the linking of the table object in Access but they did not solve
the problem still.

Any help is appreciated.

Thanks,

Ben
Click to expand...

if the checkbox is bound to a field in the table, and the field name
has changed, this problem could happen, and with it does, a status bar
message will appear in the bottom left of the access applicatio
something like "control can't be edited, its bound to an unknown
field"

if you open the table in access, can you
a) change the current value of the field for a given record ?
b) create a new record ?
 
Back
Top