Dynamic queries - user controlled in a form?

[pat_nospam]

Okay - I didn't know whether to post this in queries or forms, so I'll try here first.

My users need to be able to have more control over extracting data from the tables in a dynamic fashion. I envision them being able to go to a form, click on a pull down box which is populated with the table names - which, when clicked populates another pull down box with field names, which they can then select multiple field names and populate a report with them.

Is such a venture possible? Is there a straight forward method to doing this?

Currently, I just generate commonly used reports for them, but they want to have more control with fewer phone calls to me for development of queries.

Thanks in advance for all your help!

Pat

 

[wizcow]

Pat

There is a tutorial here that might help.

Querys On The Fly

Good Luck
Tom

 

[vengsiva]

Pat
Please visit.A number of forms are available here
http://www.rogersaccesslibrary.com/
I found the following very usefuls
http://www.rogersaccesslibrary.com/download2k.asp?SampleName='CreateMultiSelectQuery2k.mdb'
Vengsiva