Results 1 to 2 of 2
  1. #1
    Eranka is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    150

    Missing Operator

    Hi



    Code:
    CurrentDb.Execute "Update Attendance SET [Actual T2] = '" & Me.Text4 & "' WHERE [Enroll ID] = & Me.Combo0 & AND [Date] = & Me.Combo2 "
    when i run the above code error message appears as Missing Operator, im unable to find it. Appreciate your help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You didn't stop and start the quotes around the combo references like around the textbox.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Missing operator in query expression
    By moneypennie21 in forum SQL Server
    Replies: 11
    Last Post: 05-18-2017, 08:10 AM
  2. Syntax error (missing operator)
    By aamer in forum Access
    Replies: 5
    Last Post: 09-25-2014, 07:36 PM
  3. Syntax Error...missing operator
    By jgelpi16 in forum Programming
    Replies: 14
    Last Post: 09-09-2010, 11:35 AM
  4. Error 3075 Missing Operator
    By KLynch0803 in forum Queries
    Replies: 5
    Last Post: 02-11-2010, 01:13 PM
  5. Missing Operator error
    By data123 in forum Forms
    Replies: 1
    Last Post: 03-15-2009, 04:34 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