change String text to be Form Object

  • Thread starter Thread starter dom
  • Start date Start date
D

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"
 
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"
 
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.

Rob Oldfield said:
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 said:
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"
Click to expand...
Click to expand...
 
Dim formname As String
Dim subformcontrolname As String
Dim controlname As String
formname = "frmWIPEntry"
subformcontrolname = "frmWorkDone"
controlname = "Begin"
forms(formname)(subformcontrolname).form(controlname) = "abcde"


dom said:
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.

Rob Oldfield said:
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 said:
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"
Click to expand...
Click to expand...
Click to expand...
 
thank you
dom

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


dom said:
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.

Rob Oldfield said:
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"
Click to expand...
Click to expand...
Click to expand...
 
Back
Top