B
boomer
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
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