Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: Run-time error 3077??

    Hi! Could anyone help me with this please?!?

    I have problem returning certain records on a form.
    I'm using a combo box to select a record from a table and
    displaying the corresponding record fields in text boxes on a form.

    But on occasions when I select from the combo box I get the following message:

    Run Time Error 3077, Syntax Error (missing operator) in expression.

    I'm a total beginner with VBA and pretty clueless but here's the highlighted section that appears in the debugger:

    Private Sub Combo22_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Title] = '" & Me![Combo22] & "'"
    Me.Bookmark = rs.Bookmark
    End Sub

    Any help would be hugely appreciated!! Thanks in advance!

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    My first guess would be that the selected record in combo 22 contains an apostrophe or some other non-aplhanumeric character that is messing up your FindFirst line. If this is the case, use a different field, like the primary key, to do your searches and have the Title field just for display for the user.

Posting Permissions

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