Filter a recordset

[ionutdinulescu]

I have the following code :
Lista.Recordset.Filter = cbCampuri.Value & _
"='" & _
txtValoare.Value
Lista.Requery

where my Lista is a listbox.
The problem is that this listbox doesn't apply the filter. What else should I write here ?

 

[PHV]

Dynamically rebuild the Lista.RecordSource with a WHERE clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ionutdinulescu]

This is ok for filtering but it gives an "Object invalid or no longer set" error when I try to delete any record with Lista.Recordset.Delete. It's working fine if I don't have a WHERE clause.