If you have a form (tab view) continuous records.
When you start adding more boxes to filter, it has to be an option...
Put the filter controls on the header and a button APPLY FILTER
the button AFTERUPDATE event is:
Code:
dim vFilt
if not isnull(cboST) then vFilt = vFilt & "[state]='" & cboST & "' and"
if not isnull(txtName) then vFilt = vFilt & "[Name]='" & txtName & "' and"
if not isnull(txtProd) then vFilt = vFilt & "[Product]='" & txtProd & "' and"
'remove the last AND
vFilt = Left(vFilt, InStrRev(vFilt, "AND") - 1)
'Apply filter
me.filter = vFilt
me.filteron = true