Need Search Code For VB using MS access as database

[dismantle]

Hi all,
I need code help to perform a search code using access database
i tried to search other threads but only saw this thread http://www.thescripts. com/forum/thread580180.ht ml
and its very detailed but problem is its for sql server i fink

[maxamis4]

Could you be more specific on search code?

[dismantle]

im putting a textbox for the users to input a number and it searches for the exact number in the database and will be shown in my other textboxes

heres my code in conencting to my databse
con.ConnectionS tring = "Provider=Micro soft.Jet.Oledb. 4.0;Data Source=C:\Tribe ndatabase.mdb"
con.Open()
sql = "Select*Fro m Codes"
da = New OleDb.OleDbData Adapter(sql, con)
da.Fill(ds, "Virtual")

con.Close()
Maxrows = ds.Tables("Virt ual").Rows.Coun t
inc = -1

all i need now is the syntax how to do a search

[maxamis4]

Change the sql

dim myValue as number
con.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Tribendatabase.mdb"

myValue = Your_textbox.text

        con.Open()
        sql = "Select*From Codes where [yourfield]="myValue

        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(ds, "Virtual")

        con.Close()
        Maxrows = ds.Tables("Virtual").Rows.Count
        inc = -1

[dismantle]

ok thnx ill try