Ok I have to create on the fly a dynamic search query when the user
completes a form, this could have from 1 up to about 15 search values. Is
there any pages or sites that recommend a good way to do it. currently i do
it the following way
'set aWhere to false so we know when to add the and into the SQL statement
aWhere = "False"
'builds the SQL string
strSQL = "SELECT CMPNY_NO, CMPNY_NAME, PREV_CMPNY_NAME, REG_POSTCODE,
STATUS, TRAD_POSTCODE, TELEPHONE FROM Company WHERE "
IF txtComp <> "" then
strSQL = strSQL & "(CMPNY_NAME like '" & ...