Problem with recordsource in a subform... 1

[sagamw]

I have a form "Eikones" and a subform as a continuous form called "EikThumb".

The source of my subform "EikThumb" is a query, but in some point I want to change the source of my subform, to another query "Query2".

I am trying

=[forms]![Eikona]![EikThumb].RecordSource = "Query2"

but It doesn't work and I get Error 438 Object doesnt support this property or method.

Am I doing something wrong?
.
.

 

[PHV]

VBA code:

Forms!Eikona!EikThumb.Form.RecordSource = "Query2"

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

 

[sagamw]

Thank you PHV!
You saved me a lot of trouble today (twice!!)

I guess I have a lot to learn about the syntax of VBA, SQL etc.
:-(