Run-time error '3075' with dlookup

[Vasago]

I can't seem to get this dlookup to work correctly. I have double check all the spellings.

This is the error I'm Receiving.

Run-time error '3075':
Syntax error in query expression '[Trip Date] = #7/8/2014# and School = 'The A Group' and Amount =$409.78'.

Here is the code:

[Invoice #] = DLookup("[Invoice #]", "Invoices", "[Trip Date] = #" & Forms![charter order form]!Date & "# and School = '" & Forms![charter order form]!Client & "' and Amount =" & Forms![charter order form]!Quote)

Thanks for your help.

[Rabbit]

Remove the dollar sign.

[NeoPa]

The value in [Quote] is not numeric. It's a formatted string which contains a character ($) which precludes it from being recognised as a numeric value.

You can lose it in various ways, but a simple way would be to say :

[Invoice #] = DLookup("[Invoice #]", "Invoices", "[Trip Date] = #" & Forms![charter order form]!Date & "# and School = '" & Forms![charter order form]!Client & "' and Amount =" & Replace(Forms![charter order form]!Quote, "$", ""))