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.
"Roger" <le*********@na tpro.comwrote in message
news:7e******** *************** ***********@w7g 2000hsa.googleg roups.com...
On Jun 4, 10:12 am, "Ben" <pilla...@sbcgl obal.netwrote:
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
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 ?