"Find" record problem

[glendower]

Im 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

 

[Gunthar]

Hrmm in ADO.NET you dont 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