Filtering records using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

capax.solutions@gmail.com - 22 Mar 2007 15:36 GMT

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?

Reply to this Message

Marshall Barton - 23 Mar 2007 01:01 GMT

>How can I filter a recordset used in a form record by record
>programatically rather than via SQL?
[quoted text clipped - 3 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message