stLinkCriteria Date & Text

[Oscar_W]

I have spent most of the day on this and despite searching through the Forum I have not found an answer

stLinkCriteria1 and stLinkCriteria2 work on their own, but when I try to join them to use both the date and text I get a type mismatch....

stDocName = "Operations_By_Unit"
testdate = Date
testdate = Format(testdate, "MM/DD/YYYY") ' Converts date format to US for Findfirst

stLinkCriteria1 = "[StartDate] = #" & testdate & "# "
stLinkCriteria2 = "[Unit] = " & Chr(34) & Me!CboUnit & Chr(34)

stLinkCriteria3 = ("[StartDate] = #" & testdate & "# ") And ("[Unit] = " & Chr(34) & Me!CboUnit & Chr(34))

Me.Undo
DoCmd.Close acForm, "PreOpen"
DoCmd.OpenForm stDocName, , , stLinkCriteria3

Oscar

 

[FLM]

Try this:

stLinkCriteria3 = "[StartDate] = #" & testdate & "# And [Unit] = " & Chr(34) & Me!CboUnit & Chr(34)

Frank

 

[Oscar_W]

Frank,

That's the beasty ! It's easy when you know how.

Thanks.