DoCmd Open Form Syntax Error (1 Viewer)

FreddyK

New member
Local time
Today, 20:36
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
 

plog

Banishment Pending
Local time
Today, 05:36
Joined
May 11, 2011
Messages
11,643
Remove the last ampersand and everything after it
 

FreddyK

New member
Local time
Today, 20:36
Joined
Sep 2, 2017
Messages
3
Thank you for you help! Removing those characters has cleared the syntax error.
 

Users who are viewing this thread

Top Bottom