Set a MS Access Report Recordsource from a script

[Malc8179]

Hi Guys

im trying to change a reports recordsource from a bit of code

im using
Reports!GND37R01.RecordSource = "qrygnd37r01"

and i get a runtime error 2451

any thoughts

 

[robcarr]

have you tried

me.RecordSource = "qrygnd37r01"

just a thought

Hope this is of use, Rob.

 

[robcarr]

i was close it should be like

me.RecordSource = "SELECT * FROM [qrygnd37r01]"

should work.

Hope this is of use, Rob.

 

[Malc8179]

Thanks worked well