Reading from Database

[Stiletto]

I got this so far:

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?

[vishalmarya]

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

[Stiletto]

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

[vishalmarya]

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

[Stiletto]

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

[Stiletto]

I had this b4:

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

Wwhat is the blank space for?

[vishalmarya]

Originally posted by Stiletto
I had this b4:

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

[jcfowl]

it does nothing. Get rid of it.