G
Guest
I have 2 combo boxes that I want the user to use to select data for the
subform display (Client Number and SaleDate).
I created the form with the wizard for the first combo box, and have tried
to modify the code to include the second.
I get the error: Syntax Error (Missing operator) in Expression.
on the rs.FindFirst statement.
Probably simple, but there's no one here I can ask to look at this.
Code Below:
Private Sub CboclSaleDate_AfterUpdate()
' Find the record that matches the control.'
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[clNum] =" & Str(Me![cboClNum]) & "[SaleDate] =" &
Str(Me![cboclSaleDate])
Me.Bookmark = rs.Bookmark
End Sub
Many thanks,
sara
subform display (Client Number and SaleDate).
I created the form with the wizard for the first combo box, and have tried
to modify the code to include the second.
I get the error: Syntax Error (Missing operator) in Expression.
on the rs.FindFirst statement.
Probably simple, but there's no one here I can ask to look at this.
Code Below:
Private Sub CboclSaleDate_AfterUpdate()
' Find the record that matches the control.'
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[clNum] =" & Str(Me![cboClNum]) & "[SaleDate] =" &
Str(Me![cboclSaleDate])
Me.Bookmark = rs.Bookmark
End Sub
Many thanks,
sara