I am trying to build a simple search form to filter records from the database. I provide two sets of unbound fields each set made up of a combobox holding the field names and a text box for user input. Ideally I would like to link the sets with and/or/not selectors.
My idea was to take the contents of the 4 boxes and write a SQL statement to do the selection. I can't work out how to specify field names though - only the user input is ok but the field name parameter doesn't work as a field.
Is there a simple fix?
My idea was to take the contents of the 4 boxes and write a SQL statement to do the selection. I can't work out how to specify field names though - only the user input is ok but the field name parameter doesn't work as a field.
Is there a simple fix?