Two find examples do not work with the syntax I use:
Example One
Set rs = Me.Recordset.Clone
Rem Symbol is a number field
str = "[SYMBOL] = " & Me![Combo23]
REM gives argument not optional error
REM Print "[SYMBOL] = " & Me![Combo23]
REM [SYMBOL] = 7344
Set rs = Me.Recordset.Clone
rs.FindFirst str
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Example Two:
Rem TRANS_AMOUNT is a currency field
rs.FindFirst "[TRANS_AMOUNT] = " & Me![Combo25]
REM gives
REM Syntax error in expression, Error 3077
REM Print "[TRANS_AMOUNT] = " & Me![Combo25]
REM [TRANS_AMOUNT] = $536,181.36
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
I have no problem with string fields and dates. Help please