Access 2007 and Macros - breaking my head open

1ddqd

I'm using a template for an Access 2007 database that's available online at Microsoft.com

I'm having trouble though...


...this is what my list looks like:


This is the error I get when I open the list form above:


The problem is, each control on the form has an embedded macro. Stupid I know, but I changed a crucially linked control's name from ID to Loan Number. When you click "Loan Number" it should open the "Issue Details" form, but it doesn't. It's recognized as a hyperlink, but doesn't do anything. Here's the macro for that process:


I had to go through and repair like 100 broken macros at that point, but I think I got all except this one. Is there a way to find which macro is giving me this error and likewise find others?

Or, if I have to start over, is there an easier way to rename everything to begin with?

mspencer

You have an identifier called [Open Issues].ID that it doesn't know how to find. Where is the table or query [Open Issues] defined? If it's not, you'll need to change that name to match an existing table or query.

1ddqd

mspencer wrote: »

You have an identifier called [Open Issues].ID that it doesn't know how to find. Where is the table or query [Open Issues] defined? If it's not, you'll need to change that name to match an existing table or query.

I have no clue - inside the "OpenIssues" there are multiple controls that have embedded macros. I was hoping there was a way to search for it or something...or trace the error route or something.