Exclding Query Fields in a Form

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
 
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
 
Back
Top