DoCmd Open Form Syntax Error

FreddyK

New member
Local time
Today, 23:52
Joined
Sep 2, 2017
Messages
3
Hello, could somebody please help me with the syntax error I am getting on the code below

Code:
DoCmd.OpenForm "frmWorkOrder", , , "VAPLZ like" & "'" & "*" & Me.cboVAPLZ_AUFK & "*" & _
" And  " & "AUART Like " & "'" & "*" & Me.cboAUART_AUFK & "*" & "'" & _
" And  " & "KTEXT Like " & "'" & "*" & Me.txtKTEXT_AUFK & "*" & "'" & _
" And  " & "PRIOK Like " & "'" & "*" & Me.cboPRIOK_AFIH & "*" & "'" & _
" And  " & "STRNO Like " & "'" & "*" & Me.txtSTRNO_IFLOS & "*" & "'" & _
" And  " & "REVNR Like " & "'" & "*" & Me.cboREVNR_AFIH & "*" & "'" & _
" And  " & "IWERK Like " & "'" & "*" & Me.cboIWERK_AFIH & "*" & "'" & _
" And  " & "INGRP Like " & "'" & "*" & Me.cboINGRP_IFLOT & "*" & "'" & _
" And  " & "Expr1 BETWEEN  #" & Me.Text44 & "# AND #" & Me.Text52 & "#" & "'"
Thanks
 
Remove the last ampersand and everything after it
 
Thank you for you help! Removing those characters has cleared the syntax error.
 

Users who are viewing this thread

Back
Top Bottom