Query Based On User Selection

[Chuck]

Hello,

I have a from with several combo boxes. I would like the
user to be able to pick the table he want to query from a
combo box as well as all the fields he wants to query. I
would then show a report based on all his selections. Is
there an easy way to make a query that would be based on
all the combo box selection the user made.

Thanks,
Chuck

 

[John Spencer (MVP)]

No, there is no EASY way. The only way I know to do this sort of thing is
through VBA code and building the SQL statement.

 

[Duane Hookom]

I have a complete "applet" that can be imported into any MDB to provide this
type of functionality. The demo with all the forms, code, tables etc are at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.