Reading from Database

I got this so far:

VB Code:

Set DB = OpenDatabase(App.Path & "\Stilo.mdb")
  'Open the Contact table
  Set RS = DB.OpenRecordset("SELECT * FROM Contact WHERE # = '" & 5 & "'")
 
What do i do next?
How do i read the value to a textbox?

Quote:

---

Originally posted by Stiletto
I got this so far:
How do i read the value to a textbox?
[/Highlight]

---

Not clear ,

u mean write to textbox

i'm using ADO.
How can i read the fields and write it to a textbox (or label...whatever)

Quote:

---

Originally posted by Stiletto
i'm using ADO.
How can i read the fields and write it to a textbox (or label...whatever)

---

Ado or dao does not matter ,
u will be creating a recordset as in this case ,


text1 = RS!fieldname

or

text1 = RS.fields("fieldname").

u have 1605 posts to your name , what were they related to !! just curious ;)

lol.
Many things, but i'm new to all the database things...:)

I had this b4:

VB Code:

frmMain.Text5.Text = "" & RS!Artist

Wwhat is the blank space for?

Quote:

---

Originally posted by Stiletto
I had this b4:

VB Code:

frmMain.Text5.Text = "" & RS!Artist

Wwhat is the blank space for?

---

frmMain.Text5.Text = "" & RS!Artist

or

frmMain.Text5.Text = RS!Artist


doesn't make any difference

it does nothing. Get rid of it.