Exclding Query Fields in a Form

[Manuel]

Is it possible to exclude fields in a query from a form?
Lets say I have a query with 200 fields. I want to, from
a form, be able to select a subset of those 200 fileds to
use in a query. Amost like building a query from
scratch, but without going into design view. Basically I
want to be able to have access to the "Show" option from
a Form.

Anyone got any ideas.

Thanks.

Manuel

 

[Nikos Yannacopoulos]

Manuel,

I've done it in the following way: for each field I have a checkbox to
select/deselect. I use VB code to cycle through the controls and construct
an SQL string including the fields corresponding to the checked boxes, and
save the SQL string as a QueryDef or, make the SQL string an append query
and put the results in a temporary table.

HTH,
Nikos