URGENT, ADO/ Recordsets

[EscapeUK]

HELP (VB)

OK we are using ADO here,

I need to search in a table to find some data.

For example locate a customer ID, then also retrieve the customer firstname, last name etc,

Thanks )

[JHausmann]

Dim g_Db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sTmp As String
Dim sQry As String


sTmp = "File Name=" & App.Path & "\Database.UDL"
g_Db.Open sTmp

sQry = "select firstname, lastname from table where customerid='" & Trim(form.textfield) & "'"

rs.Open sQry, g_Db


[Edited by JHausmann on 06-05-2000 at 06:39 PM]