How can I dynamically select the form field to assign to a variable in VBA

[parrib1]

Dim formItemS As String, ParmString As String
ParmString = "TelephoneNum1"

formItemS = Forms!frmMacRequestsInputAdd!TelephoneNum1

Debug Results

? formItemS
5555555555

I want to do this and get 5555555555

formItemS = Forms!frmMacRequestsInputAdd!ParmString

I need to know how to dynamicaly input which field to move to formItems.

[MikeTheBike]

Hi

Maybe somthing like this

Dim formItemS As String, ParmString As String
ParmString = "TelephoneNum1"

formItemS = Forms("frmMacRequestsInputAdd").Controls(ParmString)


MsgBox formItemS

??

MTB

[NeoPa]

Quite right. An alternative for line #4 would be :

formItemS = Forms!frmMacRequestsInputAdd.Controls(ParmString)

[parrib1]

Exactly It

That was exactly what I needed. I knew it was something relatively simple.

Thank you very much!!