[AccessD] A2K: Pass Field Name to function

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



More information about the AccessD mailing list