OpenForm with two filters

Xenix

Registered User.
Local time
Today, 20:44
Joined
Oct 8, 2001
Messages
124
I have this code to open a form from a form with the following code:
DoCmd.OpenForm "Special", , , "
=" & Forms!Quotation!quote & "[Item]=" & Forms!Quotation!QuotationProducts!Item

But I get the error message:
Syntax Error(missing operator) in query expression '
=6004[Item]=1'.

Can anyone help me?

Thank you in advance
Mike
 
Code:
"[quote] = " & Forms!Quotation!quote & " AND [Item] = " & Forms!Quotation!QuotationProducts!Item
 

Users who are viewing this thread

Back
Top Bottom