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>
__________________________________________________
_________________________