Filtering records using VBA

[capax.solutions]

How can I filter a recordset used in a form record by record
programatically rather than via SQL?

I have a fairly complex vba function that can decide whether the
record needs to be displayed or not in the form but it's difficult/
impossible to convert into an SQL statement. Is there any way I can do
this?

 

[Marshall Barton]

How can I filter a recordset used in a form record by record
programatically rather than via SQL?

I have a fairly complex vba function that can decide whether the
record needs to be displayed or not in the form but it's difficult/
impossible to convert into an SQL statement. Is there any way I can do
this?

If you are using the (default) database engine, Jet, you can
call your function in a query's WHERE clause. e.g.

SELECT fa, fb, fc, . . . FROM table WHERE yourfunc(fx,fy,fz)

OTOH, maybe your situation will yield to a clever
combination of query operations.