The identifier '[tblAudit].[Area] could not be found?

Access_

New member
Local time
Today, 08:20
Joined
Jun 21, 2014
Messages
2
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!
 
SOunds like on the *open and add defect* Form there is a missing control. While in Design Mode of this Form look at the Controls on the Form, make sure you check *under* larger Controls, and see if you can find it.

If not there check the RecordSource for the Form and see if it's there, including checking if you running an query/s attached to the Form.
 
I triple checked everything (except where the problem is???). I even went to the database documenter, and looked through the table and forms possibly related to this issue.
I'm sure you are right about a missing control, because I did have the tblaudit.area field in my table in the beginning. I removed that field, and didn't think it was being used anywhere else. Obviously, it is somewhere...but I don't know where else to look or how to correct it.

Thank you for your suggestion...I appreciate any info you have!
 
Do you *Track Name Autocorrect info*, under Options checked or unchecked? When was the last time you ran Compact & Repair?
 

Users who are viewing this thread

Back
Top Bottom