Using variable for control in function

[baronvont]

I am trying to use a variable to test if a use has pressed shift on a control.. that part is all well, but I need to know which control will be affected. The function carries the control name into it under the variable 'Ref'. How do I use this to get the value from the referenced control?

(This doesn't work!)

Function GetSearch(Ref As String)

Dim strInput As String, strFilter As String


If SecondFunction = 1 Then ' If shift has been pressed
strInput = Forms![F Job]!Ref.Value
Else
..............

 

[Norris68]

Forms("F Job&quot.Controls(Ref)

 

[baronvont]

Perfect.. many thanks