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
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