Report not being completed properly

[Awes]

Hi

I have been tasked with putting together a db for my place of work.

I am using Access 2007 but the majority of users are using Access 2003.

This has not been a major problem to date as I developed and saved the db in Access 2003 format.

Everything seems to work as designed except for a report that it produces.

When the user clicks on a button the report is opened in print preview mode. I have some code in the report 'On Load' event that does some calculations, checks a value and dependent on the value will populate/hide certain text boxes on the report.

On my PC this works as expected but when I run it on a PC with Access 2003 it would appear that the code is not running.

Does anyone have any idea why this happening and how I resolve it?

Thanks in advance, Awes.

 

[Malcy]

Hi Awes
Just a thought but if that code was as an embedded macro - which is what ACC2007 seems determined to default everything to unless you hit it hard every time - then this could be the reason.
ACC2003 cannot run embedded macros I think.
If it has embedded it as a macro then what you need to do is to recreate as VBA on the button.
Quite a lot of ACC2007 seems pretty good but this defaulting to embedded macros is a seriously major backward step since even if you think you have turned it off in the options it still does it!!!
HTH