List Box with table Field Names and then use Field names for query

[boots3579]

I would like to be able to have table field names in a list box and have the ability to choose which fields would go into a query/report. Ideally, it would be able to move the items from a list box with all of the names to a list box with only chosen field names. How difficult is it to use the items in the "Selected Fields" listbox to turn the "Show" box in query design on or off?


My understanding of VBA is 1 on a 10 scale but can stumble through it.

Any help would be much appreciated.

 

[dhookom]

There is a complete "applet" for adhoc query/report building at

http://www.rogersaccesslibrary.com/forum/dh-query-by-Form_topic12.html.

It uses a combo box of field names to select columns to report.

Duane
Hook'D on Access
MS Access MVP

 

[boots3579]

Thank you very much!

 

[boots3579]

I need to send you a cyber six pack. That is exactly what I need.