change String text to be Form Object

[dom]

I want change a string text to be Form Object. How am I do.

e.g.

Dim a as Form
a = "Forms![frmWIPEntry]![frmWorkDone].Form![Begin]"
a= "5000"

expect : Me.begin.value = "5000"

 

[Rob Oldfield]

I'm not exactly sure what you're asking here, but you can do this...

Dim formname As String
Dim controlname As String
formname = "Whatever"
controlname = "txtVitalField"
Forms(fname)(cname) = "abdce"

 

[dom]

Thanks, it is useful to me if under such circumstance "me.begin" or
"frmWorkDone.begin". How I am express when use this
"Forms![frmWIPEntry]![frmWorkDone].Form![Begin]" as your suggested format.

I'm not exactly sure what you're asking here, but you can do this...

Dim formname As String
Dim controlname As String
formname = "Whatever"
controlname = "txtVitalField"
Forms(fname)(cname) = "abdce"

I want change a string text to be Form Object. How am I do.

e.g.

Dim a as Form
a = "Forms![frmWIPEntry]![frmWorkDone].Form![Begin]"
a= "5000"

expect : Me.begin.value = "5000"

 

[Rob Oldfield]

Dim formname As String
Dim subformcontrolname As String
Dim controlname As String
formname = "frmWIPEntry"
subformcontrolname = "frmWorkDone"
controlname = "Begin"
forms(formname)(subformcontrolname).form(controlname) = "abcde"

Thanks, it is useful to me if under such circumstance "me.begin" or
"frmWorkDone.begin". How I am express when use this
"Forms![frmWIPEntry]![frmWorkDone].Form![Begin]" as your suggested format.

I'm not exactly sure what you're asking here, but you can do this...

Dim formname As String
Dim controlname As String
formname = "Whatever"
controlname = "txtVitalField"
Forms(fname)(cname) = "abdce"

I want change a string text to be Form Object. How am I do.

e.g.

Dim a as Form
a = "Forms![frmWIPEntry]![frmWorkDone].Form![Begin]"
a= "5000"

expect : Me.begin.value = "5000"

 

[dom]

thank you
dom

Dim formname As String
Dim subformcontrolname As String
Dim controlname As String
formname = "frmWIPEntry"
subformcontrolname = "frmWorkDone"
controlname = "Begin"
forms(formname)(subformcontrolname).form(controlname) = "abcde"

Thanks, it is useful to me if under such circumstance "me.begin" or
"frmWorkDone.begin". How I am express when use this
"Forms![frmWIPEntry]![frmWorkDone].Form![Begin]" as your suggested
format.

I'm not exactly sure what you're asking here, but you can do this...

Dim formname As String
Dim controlname As String
formname = "Whatever"
controlname = "txtVitalField"
Forms(fname)(cname) = "abdce"


I want change a string text to be Form Object. How am I do.

e.g.

Dim a as Form
a = "Forms![frmWIPEntry]![frmWorkDone].Form![Begin]"
a= "5000"

expect : Me.begin.value = "5000"