I'm sure this is an easy one, but I can't seem to puzzle out the right code to use. I'm attempting to use an SQL statement to obtain a list of records and am not sure what code I should be using. Obviously RunSQL is inappropriate and I can't seem to get the RecordSet objects and methods to work properly.

You probably will need to provide a little more information.
Are you attempting to use ADODB? There are numerous tutorials and how-to's out on the web with examples of how to do this.
What specifically are you having trouble with?

Woody Z http://www.learntoprogramnow.com

I want to do a simple sql select on a table to get an id to use in an update query. A user enters a first name, last name and date of birth which I want to use as the select criteria to search a table for the associated id.

I have the SQL to obtain the id but can't remember the code to use to save the returned result.

Hope that makes sense.

This question might belong in the Beginning VB Database forum rather than this one.

If by 'save' you mean update another table, the code is as follows. Creat the appropriate DYNASET,(N.B. it is vital you create a DYNASET rather than any other type of Recordset as this is 'updateable') let's say you've called it MyDynaset then ...


MyDynaset.Edit
MyDynaset!fieldname= txtID.Text (or whatever)
 and so on for each field
MyDynaset.Update

Hope this helps.liamfitz.