Pointers. text field contains a pointer to the object, any thoughts? 1

[Gzep]

Hi.

Pointers. I have a text field that contains a pointer to the object, i am looking to get the value of the object, any thoughts?

eg: strTest = "Forms!frmSetup!txtSerial"

and if you look at the form frmSetup, in the box txtSerial it contains the string: "PM719"

using code to manipulate strTest, can i return "PM719"

I know I can do it, if I write my own .dll in c++...( but i'd rather not)

Gzep.

 

[kathryn]

OK here is an idea. Instead of referring to a form's controls using the ! syntax, it is acceptable to use parentheses. This means that if you want to refer to "Forms!frmSetup!txtSerial" you can use the syntax Forms("frmSetup&quot("txtSerial&quot.

Even better, you can use variables:

frmName = "frmSetup"
ctlName = "txtSerial"
Forms(frmName)(ctlName)

So if you can use some string functions to pull out the form name and the control name, then you can pass them and get the value in txtSerial.

Does that make sense?
Kathryn

 

[Gzep]

G'day kathryn.

Thanks, I had already thought of that, but it will have to be a more robust parser that I really have time for, as the users will (probably) entering details into the table, and I have to be able to handle all sorts of crap. ;-)

OK, looks like the way to go though.

Gzep.