Search results

is it possible to delete the Query criteria by for instance using an On Change event from a combo box in a form? thanks Patrick

I'm completely lost here.... ;-) i have an unbound form UFORM with a combobox CMB_CLIENT the CMB_CLIENT is bound to the ID_CLIENT in my TBL_CLIENT on the UFORM i have a SUB_UFORM which is bount to a query qry_TEST the qry_TEST is: SELECT * FROM TBL_CLIENT WHERE ID_CLIENT=...

using CMBBOX does not really work either. If i make no selection on the CMBBOX, my query is not responding any results. And i wish to use the CMBBOX to narrow down the query results. Or am i doing something wrong here? Thanks

hi, im trying to develop a dynamic query depending on the data from a combobox. i managed to get this working using the LIKE * & CMBBOX & * criteria. but the *.* criteria is a little to wide. supose i use a combobox listing the client id's. If i select a client id 3 my query retruns all...