Lookup the recordset

[sabavno]

Hi

I work with the recordset based on query

I would like to look one field based on the another

If use dlookup it'd look like this
varName = DLookup("Field1", "QueryName", "[Last Name] = '"
& txtLastName & "'&quot

What should I do to achieve the same but using the recordset?

Thanks

 

[Paddyo]

SQL = "Select field1 from TableNAme where lastname = '" & txtlastName & "'"

That should give a recordset with the variable you want.
You will have to setup your connection to your database and use this sql statement with you dbconnect

Hope this helps