D
Daniel
I am getting an error using the FindFirst Method.
I am using Access 2007, but am using the old technique of DAO. Does the
database need to be saved in an older version, and not the accdb 07 version
in order for the older DAO to work. Here is my code-
1Private Sub cboCounty_AfterUpdate()
2 Dim strCounty As String
3 Dim strCriteria As String
4 Dim rst As DAO.Recordset
5
6 strCounty = Me.cboCounty.Text
7
8 strCriteria = "[Prospect]= " & strProspect
9 Set rs = Me.RecordsetClone
10
11 rst.FindFirst (strCriteria)
12 If rs.NoMatch Then
13 MsgBox "Record not found"
14 Else
15 Me.Bookmark = rs.Bookmark
16 End If
17 End Sub
Line 11 is the problem
Error: Run time error '3077'
Syntax error (missing operator) in expression
Can someone help, please, Thanks
I am using Access 2007, but am using the old technique of DAO. Does the
database need to be saved in an older version, and not the accdb 07 version
in order for the older DAO to work. Here is my code-
1Private Sub cboCounty_AfterUpdate()
2 Dim strCounty As String
3 Dim strCriteria As String
4 Dim rst As DAO.Recordset
5
6 strCounty = Me.cboCounty.Text
7
8 strCriteria = "[Prospect]= " & strProspect
9 Set rs = Me.RecordsetClone
10
11 rst.FindFirst (strCriteria)
12 If rs.NoMatch Then
13 MsgBox "Record not found"
14 Else
15 Me.Bookmark = rs.Bookmark
16 End If
17 End Sub
Line 11 is the problem
Error: Run time error '3077'
Syntax error (missing operator) in expression
Can someone help, please, Thanks