Invalid Use of property

[Costefran]

Can anyone help

I am trying to set the row source of a control on my form based on criteria selected in a control called [report format] but I get the message Invalid use of property

I am using the following code

If Forms![Under 500 Selection for Spend Report]![Report Format] = "In Progress (Not Approved)" Then Me.Under_500_Year.RowSource "Under 500 Selection Query in Progress2"

I assume its something to do with the control [Under 500 Year]
but have no idea what to check next

Any help would be apreciated

Thanks

 

[genomon]

Me.Under_500_Year.RowSource "Under 500 Selection Query in Progress2"

Are you really missing an equal sign here, or is it a typo?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[PHV]

Perhaps replace this:
Me.Under_500_Year.RowSource "Under 500 Selection Query in Progress2"
with this ?
Me![Under 500 Year].RowSource [!]=[/!] "Under 500 Selection Query in Progress2"

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

 

[Costefran]

Worked a treat many thanks