Forms Properties

[k209310]

Hello

Is it possible to alter a reports property settings at run time using VBA. I cant seem to find the code i need to change the form.

Cheers

Chris

 

[Rich]

What you mean by property settings?

 

[k209310]

Thanks for the reply

I have Four report all of which are the same apart from their recordsource Data property. I was trying to find a way that this could be changed at run time to prevent the need of having seperate forms.

Is this kind of thing possible?

Chris

 

[k209310]

I have managed to find what im looking for using

Dim Report As Report
Set Report = "rptName"

With Report


Thanks anyway

Chris

 

[Rich]

There have been many posts on the subject, here's one of them
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47195

 

[k209310]

Cheers