Using DoCmd.OpenForm "filter Query" argument 2

[clrinc]

I have a form named “Contracts”. It’s record source is the query “selContracts” that contains a field named “ContractID”. Executing the form produces 10,797 records.
I have a table named “CofirmContIDs” that contains a key field named “ContractID” and contains 16 records.
I have a query, “selContractsSubSet”, using the following SQL string; “SELECT * FROM ConfirmContIDs INNER JOIN selContracts ON
ConfirmContIDs.ContractID = selContracts.ContractID”. Executing this query produces 16 records.
Executing opening the Contracts form using DoCmd.OpenForm "Contracts", , "selContractsSubSet" produces 10,797 records.

 

[PHV]

Have you tried this ?
DoCmd.OpenForm "Contracts", , , "ContractID IN (SELECT ContractID FROM ConfirmContIDs)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[clrinc]

Fantastic!! It works perfectly. I would never have recognized this as a "where" parameter, however I'm not an SQL heavyweight. If you could point me to documentation that covers this information I would appreciate it.
I would still like to know how to use the "filter" argument to the Openform Docmd.

Thanks Clrinc

 

[dhookom]

I am not aware of anyone who uses the filter argument. There are lots of great resources on the web regarding SQL statements and where clauses/conditions.

Tek-Tips is a great place to come with specific questions.

Duane
Hook'D on Access
MS Access MVP