Type Mismatch

  • Thread starter Thread starter carterhoward
  • Start date Start date
C

carterhoward

Hi All,

I am having problems with this filter, the "And" between the two
filters seems to be giving me a type mismatch and I'm not sure what
else i can use in it's place, if that is indeed the problem.

DoCmd.OpenForm "Service Log Edit", , , "[dateserviced] = " & " #" &
Forms![Service]![Text42] & "#" And "[serialnumber] = " & " '" &
Forms![Service]![List2] & "'"

Any one see what i am doing wrong, i'm sure it's looking me in the
face!

thanks, Carter
 
You need to put the And inside the quote, try

DoCmd.OpenForm "Service Log Edit", , , "[dateserviced] = #" &
Forms![Service]![Text42] & "# And [serialnumber] = '" &
Forms![Service]![List2] & "'"
 
Back
Top