Macro automatically runs report

Dan or anyone else who can help,

I guess the VBA coding might be a little out of my league without assistance.

Just to be more exact, here is what I want: I currently have a Form that lists every record. For the purposes of this database (for a professional basketball scout), he wants to be able to sort and filter his information however he pleases, and then wants an easy way to turn that data into a neat Report. So again, I have the Form set that lists every record and I have added a button called "Generate Report." Currently all this button will do is open up a Report I have created based off of this form. However, the Report doesn't update based on any kind of sorting or filtering that is done on the Form.

I would love to be able to set this button, once it gets clicked, to Generate a Report exactly the way the data is laid out in the Form (after any sorting or filtering of any kind). And I would love if that Report was in the precise format that my current Report is in that is linked to the Form.

If anyone could help, that would be great. Thanks!

I'm not sure if this is possible, but can I add a hyperlink to my column titles on my report and once you click it runs a macro that sorts the column?

That is something I may be able to pull off by myself.

I think this link kind of explains what I want finished.

"http://msdn.microsoft.com/en-us/library/bb243780%28office.12%29.aspx"

The thing is I don't quite understand how to make this happen.