Debugging Macro??

[Peter1662]

Hi!
I have used the "Contacts" database from the Microsoft site as a base for my database to manage visits and diagnostic data for small businesses in our city. I have made some amendments to the datbase which for the most part work fine - including adding a "visits" table. I have renamed some fields as well as the forms and fixed the VB code as necessary.
However, when I open the Contacts Detail Form, either directly or using the "open" link on the Contacts List Form, I am presented with a dialog box that says "You entered and expression that has an invalid reference to the property Form/Report."
I suspect that I have an error in the macro that is run when the form loads, but can not see any error.
How can I best determine where the error is? Normall I use msgbox() to debug my code, but do not know how to debug a macro.
Thanks
Peter

 

[G37Sam]

Something tells me you there's a misspelt form somewhere

I normally don't work with Macro's, switch to VBA and be done with it

 

[Mr. B]

You did not indicate which version of Access you are using, but if you will open your macro in design view, and take a look at the menu options, you will find a "Single Step" option near the "run" option. You can use the "Single Step" option to move through each action of your macro.

 

[CBrighton]

If your version of Access lets you directly convert a macro to VBA then you could do that and debug it how you are comfortable doing it.