Hi everyone,
I am building a search form for my DB, and added 5 checkboxes, with comboboxes/textboxes next to them to let the user make a search selection.
They are cbPosition, cbDepartment, cbInterviewer, cbFeedback, cbRating and cboPosition ,cboDepartment ,cboInterviewer ,txtFeedback, cboRating.
So I need to loop through the checkboxes and if they are ticked, append the value of the combo or textbox next to it to the 'where' statement of the SQL string.
Any help is greatly appreciated.
Thank you
I am building a search form for my DB, and added 5 checkboxes, with comboboxes/textboxes next to them to let the user make a search selection.
They are cbPosition, cbDepartment, cbInterviewer, cbFeedback, cbRating and cboPosition ,cboDepartment ,cboInterviewer ,txtFeedback, cboRating.
So I need to loop through the checkboxes and if they are ticked, append the value of the combo or textbox next to it to the 'where' statement of the SQL string.
Any help is greatly appreciated.
Thank you