FindFirst method syntax explanation?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

findfirst date leading zero 15
search with combo box on subform 3
recordset.FindFirst 1
run-time error, "can't recognise ContactId" when using FindFirst 2
Find Method not working properly 10
findfirst with multiple columns 2
Need help understanding VB syntax of .FindFirst command 2
FindFirst method not found 2

Top