FindFirst...

[wh00t]

I am working on creating a holiday booking database, and am currently trying to get the form to look and see if a person has booked a certain day already. I am using findfirst but it's not going quite how I wanted.

this is the part of the code I'm having trouble with

StrStaffSearch = Str(Me!Staff)
StrDateSearch = Str(Me!StartDate)

rst.FindFirst "DateID = " & StrDateSearch And "StaffID = " & StrStaffSearch

I get a Type Mismatch error

when I use just one of the criteria values it works ok, but not with both.

How can I make it so that it searches on both criteria?

 

[Rich]

Are the date fields actual dates?

 

[wh00t]

no

the Me!StartDate is a combo box with the DateID field as it's root which is a number.

 

[simongallop]

First, if this is your code then you are missing an &

rst.FindFirst "DateID = " & StrDateSearch And "StaffID = " & StrStaffSearch

rst.FindFirst "DateID = " & StrDateSearch & " And {remove double quote}"StaffID = " & StrStaffSearch

Also if it is a date then it ought to be: "DateID = #" & strDateSearch & "# And StaffID = " & strStaffSearch

HTH

 

[wh00t]

thats got it, ta