Topic: Record search
There is a code fragment:
Set rsK = CurrentDb. OpenRecordset ("select * FROM kg")
rsK.FindFirst "Number =" and N and "and Date =" and Format (Me., "mm\/dd\/yy")
In I put any date, but all time turns out "True" though in the table "kg" of record with such date is not present.
Help to write please correctly?