Debugging Macro??

Peter1662

New member
Local time
Tomorrow, 03:36
Joined
Aug 30, 2011
Messages
5
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
 
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 :)
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom