Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    5

    Missing Operator error

    I'm getting a missing operator error.

    here is my code can anyone help me figure out why

    Private Sub Editloc1_Click()
    On Error GoTo Err_Editloc1_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Edit Document Out File"

    stLinkCriteria = "[Quarter]=" & Me![Quarter]
    stLinkCriteria = "[QTR Acct Nbr]=" & Me![QTR Acct Nbr]
    stLinkCriteria = "[Exception Type] =" & Me![Exception Type]


    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Exit_Editloc1_Click:
    Exit Sub

    Err_Editloc1_Click:
    MsgBox Err.Description
    Resume Exit_Editloc1_Click

    End Sub

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Just before you open the form use a MsgBox to display the stLinkCriteria to see what you have.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 11-16-2008, 09:46 PM
  2. 2007 runtime missing
    By wayfarer in forum Access
    Replies: 0
    Last Post: 07-21-2008, 02:26 AM
  3. Microsoft Access 2003-Missing Records??
    By kristenlee in forum Access
    Replies: 1
    Last Post: 04-04-2008, 06:43 PM
  4. Replies: 1
    Last Post: 06-09-2006, 03:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums