Hi all~
I am getting a notification saying "The identifier '[tblAudit].[Area] could not be found" I have searched through my forms, queries, VB & macros but cannot find what is causing this. I saw a few threads in here and tried the suggestions, but to no avail.
The situation:
I have two forms, one is to add a defect and the second is to edit an existing entry. The forms are identical (or so I thought) except I have a button to open the add defect but a hyperlink on the Audit ID number which opens the corresponding entry in the edit defect form. When I try to save the edit defect once there has been changes, I get this error. No problems with any other forms. I have an on load openargs macro to carry the value of the hyperlink to the form and before update save yes/no code.
I'm not sure if I explained the issue well, so if you need additional info...please let me know.
Thanks, in advance, for ANY possible solutions!
I am getting a notification saying "The identifier '[tblAudit].[Area] could not be found" I have searched through my forms, queries, VB & macros but cannot find what is causing this. I saw a few threads in here and tried the suggestions, but to no avail.
The situation:
I have two forms, one is to add a defect and the second is to edit an existing entry. The forms are identical (or so I thought) except I have a button to open the add defect but a hyperlink on the Audit ID number which opens the corresponding entry in the edit defect form. When I try to save the edit defect once there has been changes, I get this error. No problems with any other forms. I have an on load openargs macro to carry the value of the hyperlink to the form and before update save yes/no code.
I'm not sure if I explained the issue well, so if you need additional info...please let me know.
Thanks, in advance, for ANY possible solutions!