RecordSelectionFormula Syntax

[msay]

Can anyone tell me why this formula gets a "The remaining text does not appear to be a part of the formula." ERROR ?

Report.RecordSelectionFormula = "{ado.year} =" + "'" + Form6.Combo1.Text + "'" + "{ado.month} =" + "'" + Form6.Combo2.Text + "'"

 

[LazyMe]

It might be because of the quotes around the values (I think CR wants numbers there, not text).
Greetings,
Rick

 

[DonPeters]

try:

Report.RecordSelectionFormula = "{ado.year} =" + "'" + Form6.Combo1.Text + "' AND " + "{ado.month} =" + "'" + Form6.Combo2.Text + "'"

 

[LazyMe]

Oops, that's a nice observation too (totally missed that one....)
Greetings,
Rick

 

[msay]

Thank you Don. That worked. I've been pulling my hair out!