By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

CANNOT RETRIEVE RECORD by EMAIL FIELD

P: 1
Hello I have a query QProvvisori and a form Provvisorio.
In the form I created a combobox to find a specific record using the email

the combo has the following query:
SELECT Anagrafica.eMail, QProvvisorio.DataPrimoContatto, Anagrafica.CognomeRagioneSociale, Anagrafica.Nome
FROM QProvvisorio INNER JOIN Anagrafica ON QProvvisorio.IdAnagrafica = Anagrafica.IdAnagrafica
WHERE (((Anagrafica.eMail) Is Not Null))
ORDER BY Anagrafica.eMail;

the code is
Private Sub CasellaCombinata204_AfterUpdate()
' Trova il record corrispondente al controllo
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[email] = '" & Str(NZ(Me![CasellaCombinata204], 0)) & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

it does not retrieve the record and gives errore in the rs.FindFirst

Anybody can help?

thank you
Feb 12 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.