Adding Criteria to a report without a premade Query

[Talonjpc]

Sorry if this question seems dumb to anyone but I need some help.
Can I open a form with certain criteria without creating a premade query, like putting a SQL WHERE statement in the OnOpen or OnActivate Events? The criteria would be based on a variable


Thanks in Advance,
Vinay

 

[LittleSmudge]

YES

In the DoCmd.OpenForm structure you have the option of opening it with a Filter name OR using a WHERE clause

DoCmd.OpenForm "FormName", "FormViewType", "FilterName", "WhereCondition", "DataMode", "WindowMode", "OpenArgs"


"WhereClause" is a string expression in the form of a Where clause without the word "WHERE"


QED.

G LS