On Open Event - Dlookup error or wrong event?

[jkirkland]

I have my report that I set the grouplevel and a label in the group level when the report is run, based on the user selected criteria.

The error I get at runtime is 2427 'You entered an expression that has no value'

The string sGMFNDS is highlighted as the error and when I place my cursor over SGMFNDS it says sGMFNDS=""

Any suggestions as to where I've screwed up?

Thanks!

Private Sub Report_Open(Cancel As Integer)
Dim sGMFNDS as String

sGMFNDS = "(" & Me.GMFUND & ") " & Trim(StrConv(_
DLookup("[gmfnds]", "tblTEMPGMFUND", _
"[GMFUND]=" & GMFUND), 3))

Me.GroupLevel(0).ControlSource = "GMFUND"
Me.lblGroupHeader0.Caption = sGMFNDS

End Sub