We help IT Professionals succeed at work.
Get Started

Unsuccessful debug of  'identifier not found' error in Access 2013

Linda Quintana
Last Modified: 2015-04-15
I converted the Microsoft Access 'Goods Inventory Database' to a local database and have been modifying it to fit the needs of my company.   One of the things that I had to do was add a 'Distributor' table along with the existing 'Customer' table.   My rookie mistake was that I am using the new Distributor table and information in place of the 'Customer' table because the customer (in our case) is really the distributor and then the Customer table in the database is treated differently.    I hope that makes sense.

I have everything functioning the way that I want except for 1 thing that has been extremely difficult for me to figure out (well I have not figured it out).   I'm hoping that someone out here on this site has more knowledge than I do about 'Named Macros'.    I have attached the database for your convenience and help.  
***When the database opens, the initial dashboard please log in as 'Temporary' and use the password  'temporary'.  
On the dashboard that is current you will see   "Active Orders" -- click on either order's ID to bring up the form.
Click on  INVOICE ORDER      and you will get a message that 'orders cannot be changed once invoice -- continue?'   please click OK to continue.

###   This is where I get an error that states 'The Identifier [CustomerID] could not be found'.        The identifier needs to be [DistributorID] as I mentioned earlier about my rookie mistake to change the table.   What I found out later is that there were 'Named Macros' associated with the tables and I think that there is code somewhere in the named macros that needs to be changed.   However, I have followed the logic and cannot find it anywhere.   I have run a 'Step Into' and slowly and methodically ran through the logic and it is getting the error after the Named Macro    Orders.CreateInvoice   --   I believe the issue is the sbfOrderDetails, but I am unable to find it (see jpg document attached).   It may be an issue of just clicking on the right part of the subform to see the error, but I have tried my best without success.

I have checked the forms, subforms, named macros and I'm just not finding where the [CustomerID] is referenced.   Any help would be greatly appreciated.
Watch Question
Analyst, Business Process Development and Continuous Improvement
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE