a referencing issue... 1

[thefear]

hiya folks!

okay, I'm not sure how to articulate this problem but it should be straightforward if I just tell you what I'm trying to do.

In vba, I can do this...

Dim stDocName As String

stDocName = "frmTestForm"
DoCmd.OpenForm stDocName

...that is, refer to "frmTestForm" as "stDocName" in order to open a form.


How come I then can't refer to the form like this...?

forms!stDocName!txtTest = "something"

When I try, I'm told form 'stdocname' isn't found.

Any ideas/epiphanies would be appreciated )

 

[RoyVidar]

Try this method of referencing:

[tt]forms(stDocName).controls("txtTest")[/tt]

Roy-Vidar

 

[thefear]

Thankyou RoyVidar! This little niggle has been a thorn in my side for a while now. I'm going to name my first-born after you )

 

[thefear]

...even if it's a girl!

 

[RoyVidar]

...was just going to ask;-)

Roy-Vidar