Checking checkboxes to produce a SELECT statement
Posted on 2005-04-26
I have a list of checkboxes each one refering to a field in a query in an Access database,
I need to make it so that the user can build a query based on the boxes that they check. The only way I can think to do this is to write out about a million if statements to cover all possibilities. i.e.
if(chk1.value = vbchecked and chk2.value = vbunchecked and etc.. )then
there must be an easier way of doing this, I've got 9 check boxes, so doing as above would take a long time.
I would appreciate any suggestions