"Find" record problem

[Guest glendower]

I'm trying to find a record from a recordset using the statement:

 

m_rstBookings.Find(" room_number = '" & roomnumber & "' and client_id = '" & clientid & "'

 

But it doesnt work, the syntax seems ok.

 

Basically I need to be able to identify a single record based on 2 (or more) parameters, room_number and client_id.

 

The recordset m_rstBookings contains the fields (amongst others) 'room_number' and 'client_id'

 

Am I correct in assuming that the Find statement only works on finds using a single field, if so how do I find a record using 2 or more fields.

 

Thanks

[Guest Gunthar]

Hrmm in ADO.NET you don't use recordsets you use datasets. You could simply open a connection to your database and use an SQL statement to filter the dataset returned from the database. If you need example code on how to do this send me an e-mail: Phylum@Rogers.com

 

Gunthar