Filtering records using VBA

  • Thread starter Thread starter capax.solutions
  • Start date Start date
C

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?
 
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?
Click to expand...


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.
 
Back
Top