i know that a select statement is the best way to go around retrieving records from a database. the problem im facing is selecting a record then assigning a certain field from that record to a variable eg x.....
so in simple english, it has to be something like....select clientnumber from members where firstname= txtfirstname.text
the code im using to retrieve the record is
Set ri = deSub.conn.Execute("SELECT clientnumber FROM individualsubs WHERE firstname = '" & txtfname.Text & "' AND surname = '" & txtsurname.Text & "'")
so how do i assign the clientnumber to a variable x, so that i can display it in a textbox.
thank you in advance!!