Report Record Source on the Fly

[cagay]

Can someone please tell me how can I change the record source of my report before opening my report. Currently am doing manually change the record source by going to design view and change manually.

Any help would be appreciated,
thanks,
cagay