dynamic sql (flexible query)

  • Thread starter the_dude via AccessMonster.com
  • Start date
T

the_dude via AccessMonster.com

Dear all,

I am trying to create a form where the user can choose from 40 different test
which ones he/she would like to include in the query. The query will have
some fields which will always be part of it but then I would like to take
input from tick boxes from a form so that the user can choose to include 1, 2,
3, or all of the fourty tests and in any combination.

I have read about dynamic sql and looked up a few threads here but am still
very much a novice at all this VBA coding.

Does anyone have any good advice on how I can achieve this?

Thank you very much in advance for all your help.

Olli
 
Top