search access database for particular record

Dont remember the syntax but it's all over the forum:

build your query

select * from yourTable where book='" And txtbook.Text And ",Price='" and txtPrice.Text

if there can be a situation where there are no parameters - you should edit your query.

When done.
dim conn
dim rs
rs.open conn,query - or something close - I'm one sec from bed - so I'm sorry its not the exact syntax :sick:

How do I get the record info that was found to show in textboxes?

CStr(.Fields("userID").Value)

Whats the cstr? Is this the name of the recordset?
For example? cstr as adodb.recordset
CStr is a built in VB function that will convert the value passed to a String, if it can.

In that code example, adoRecordset is the name of the recordset object. I just use With adoRecordset so that, while within the With block, I don't need to type adoRecordset when I want to access the properties and methods of the object.

You can use a With block for any control or object (or subobject of a control or object, or subobject of a subobject) to lessen the amount of typing needed.

For example, create a new project, add a command button, then, in Form_Load, type:
With Command1
Then, on the next line, just type a period, and you will have intellisense showing you all the properties and methods of Command1 as if you just typed:
Command1.

If you do use With blocks, though, remember to put an End With before you end the sub or function (best time to do End With is when you aren't accessing the object or control frequently in code).

'Connect to database and set recordset connection, cursor type, and lock type

Can you give me som sample code on how to set cursor type, and lock type?
A small example:
Dim adoConnection As ADODB.Connection
Dim adoRecordset As ADODB.Recordset

'Establish connection object and connect to database
Set adoConnection = New ADODB.Connection
adoConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourAccessDatabasePath.mdb;Persist Security Info=False"
adoConnection.Open

'Establish recordset object, set cursor type, lock type, and the connection
Set adoRecordset = New ADODB.Recordset
adoRecordset.CursorType = ADODB.CursorTypeEnum.adOpenKeyset
adoRecordset.LockType = ADODB.LockTypeEnum.adLockOptimistic
adoRecordset.ActiveConnection = adoConnection.ConnectionString
You will have to change what is in blue to be the location of your Access database.

And if you have any more questions, please ask them in the forum and not in a private message. There are others who can and will help you if you need it.