FindFirst method syntax explanation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When constructing the criteria string for a combo box to lookup a numeric
value (or text or date for that matter) what is the ampersand for? For
example, in the following sample code:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Me![cboLookupContact]
Me.Bookmark = rs.Bookmark

Also, the last double quotation mark is outside the equals sign, which means
that the equals sign is part of the criteria string. This syntax is
confusing me. Can someone please explain each item of the syntax starting
with "rs.Findfirst"?
I am using Access 2000.
Thanks
 
Back
Top