First of all, thanks a lot to everybody who reply to my last question... It'S very appreciated!

But I have another one..

In my database I have a Column named Date Out in Date format. When a customer rent a room, the program write the 'Date In' and put 01-01-01 in 'Date Out'. When the customer leave the room the program write the 'Date Out'.

When I rent a room I would like to know if I can rent it to the customer so I do a rs.FindFirst with the date_out beacause if the date is 01-01-01 it's beacause the room is rented to another customer...

rs.NoMatch always return TRUE but it's not true...

Public Function fnCanLocateRoom(rs As Recordset)

With rs
.FindFirst "'Date Out' = '01-01-01'"
If .NoMatch = True Then
fnCanLocateRoom = True
Else
fnCanLocateRoom = False
End If
End With

End Function


Thanks again!

Yannick Lepage