Darren DICK
d.dick at uws.edu.au
Wed Apr 9 23:08:55 CDT 2003
Hello all The commented code below works fine. That is if I type the FieldName in directly What I want to do is pass in the FieldName from passes parameters I just can't get the syntax right. Any help or suggestions would be most appreciated Many thanks Darren __________________________________________________ _________________________ Function fComboDoubleClick(stFormToOpen As String, stFieldToFilter As String) <code Snip> DoCmd.OpenForm stFormToOpen ' This line works 'The line below works when BroadcastTypeID is typed in Manually 'Forms(stDocName).RecordsetClone.FindFirst "[BroadcastTypeID ]=" & Me.ActiveControl 'The line below fails whan I try and pass the field name as a parameter Forms(stDocName).RecordsetClone.FindFirst " & stFieldToFilter & = " & Me.ActiveControl <code Snip> __________________________________________________ _________________________