simple syntax for putting a variable into a function

[markjkubicki]

how would shoud I write this function where the name of the form is a variable : "strCurrentEntryForm" ?


(this should be a no brainer... but maybe I have no brain left LOL !)

Dim strCurrentEntryForm As String
If <...>
strCurrentEntryForm = "frmSpec"
End If

varX = Nz(DLookup("[Rep Agency]", "Manufacturers", _
"[ManufacturerName] = """ & Forms![strCurrentEntryForm].[Manufacturer] & """"))

many thanks in advance,
Mark

[June7]

varX = Nz(DLookup("[Rep Agency]", "Manufacturers", "[ManufacturerName] = """ & Forms(strCurrentEntryForm).[Manufacturer] & """"))

[markjkubicki]

exactly
thnx !