Record Source question

[fieldling]

I have one report I want to use as an invoice but have different record sources for it. For example I have a command button on a form which opens the report to show all of todays orders. On another form is a button to show the report for that particular customer.
I need to change the record source of the report depending which button was used.
I have tried using an If and Callform statement in the OnOpen section of the report but no luck.
I've also looked at similar threads in the forum but can't find what I need.
Anyone have any suggestions?

Thanks

 

[KenHigg]

One way to do this is to send the query name in the reports openargs property.

 

[KenHigg]

See if this helps

 

[fieldling]

Hi Ken

That works perfectly! Thanks for helping me out yet again.

Something else you might be able to answer for me: I have a database that opens fine on my laptop and home pc but when I try it to open it on the office pc the command buttons are all over the place and everything is pushed to the left. They all use the same OS and version of access. Is it a monitor issue?

Thanks again

 

[KenHigg]

Glad you have it working.

The only thing I can think of is maybe the screen resolution? I try to develop to the lowest screen res I anticipate having to deploy to. For example if you build a form for a screen res set at 1024x768 and then open it on a screen set at 800x600 things can get screwy -

All of it could be some other issue like the OS or MS Access versions but I haven't heard of anything like that...

 

[fieldling]

Yeah I'm pretty sure it's the screen. Will check it out. Thanks.