Hi, I have 2 questions:

1. I attempted to build a dynamic report found at http://www.fontstuff.com/access/acctut19.htm ; however, all sorts of weird stuff happens when I follow the code exactly. Does anyone know of another tutorial or version of this?

2. Is there a way to make a prompt that allows the users to choose what a data source is for the report. It is time consuming to click.the report -> design view -> view -> options -> data source.

Any help is greatly appreciated.! thx