Results 1 to 2 of 2

Thread: DoCmd Open Form

  1. #1
    Join Date
    Sep 2017
    Posts
    1

    Unanswered: DoCmd Open Form

    Hello all,

    I have a question please. The below script returns a syntax error. Can somebody help please?


    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 heaps

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,096
    Provided Answers: 17
    Are all of the table columns set to text?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •