Converting Macros to VBA in Access 2007
Posted on 2009-02-24
I am creating a simple form to use in Access 2007. I have buttons on the form for next record, previous record, save record, etc. If I create the button using the wizard it works fine, and I am able to navigate through the records. However, I need to add additional code to the buttons so they can do what I want them to do. When I convert the macro to VBA and try to use the buttons, they no longer work. I created a form like this in Access 2003 and did not have any problems. Then again in Access 2003 I wrote the code for my buttons myself. I can tell that the code has changed a little in Access 2007, but why do my buttons stop responding as soon as I change to VBA?