Passing a fieldname as a parameter

[anthonys]

I have an issue i would be grateful for some assistance on.

I have a function that has a fieldname passed into it (relevant code below). i then want to use that fieldname to reference it on a form but it does not accept it.

What am i doing wrong??

Any suggestions will be greatly appreciated!!

Private Function OpenSelectedFiles(Image As String)
'Opens files which have been double clicked on the sub-form
Dim szFileToOpen As String

On Error GoTo ErrorHandler

szFileToOpen = Forms!frmSchemes.Form. & Image
Application.FollowHyperlink (szFileToOpen)

Exit Function

 

[WayneRyan]

Anthonys,

Something like:

szFileToOpen = Forms!frmSchemes.Controls(Image)

Wayne