I have built a database in 2007 but saved it as 2000 compatible. I built a form with an option group with only two options and a button. The embedded macro behind the button Closes any open report then has conditions that OpenReport A or B.
Everything works fine in Access 2007. When another user opens it in Access 2003 the buttons don't work. His security setting is set to low so he is not even prompted to enable macros.
Any suggestions as to why the buttons aren't working?
Thanks.