How can I build a query from a form in access 1

[JaneBeech]

Can anyone tell me how to makea userform to select which fields to display as the result of a query? This would be the equivalent of ticking the 'show' boxes in a QBE design grid. I

 

[FieroFixer]

I'm not sure if I completely understand the question, but If I was going to do something like that with ASP, I would make a two step form that first presented the user with a list of choices of fields to query, and then based on the selections, pass the variables to the second part of the form using a querystring and have that part of the form build the SQL statement.

 

[Lee24]

HI,

I have just completed what u r looking for! If you wish the code and example please let me know !

regards

Lee

 

[JaneBeech]

Attn Lee24

Yes please I would like the code, but I don't know how to contact you directly! I'm in the UK

Jane BeechI