OpenForm FilterName

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RD - 15 Sep 2005 19:22 GMT

Hi all,

Help says that the FilterName argument is "A string expression that's the valid
name of a query in the current database."

I'm wondering if it *has* to be a named query or can one use an SQL statement
for that argument?

Thanks,
RD

Reply to this Message

Alex Dybenko - 16 Sep 2005 14:12 GMT

Hi,
yes, this should be a named query.

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi all,
>
[quoted text clipped - 8 lines]
> Thanks,
> RD

Reply to this Message

RD - 16 Sep 2005 17:54 GMT

>Hi,
>yes, this should be a named query.

Bummer. Thanks.

Reply to this Message

Kevin K. Sullivan - 16 Sep 2005 20:37 GMT

> Hi all,
>
[quoted text clipped - 6 lines]
> Thanks,
> RD

The next argument, WhereCondition, will accept a SQL Where clause
without the "WHERE ". Can you use this instead? I often use this
mechanism to filter a form with a criterion that is built at run-time.

HTH,

Kevin

Reply to this Message