OpenForm FilterName

  • Thread starter Thread starter RD
  • Start date Start date
R

RD

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
 
RD said:
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
Click to expand...

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