Syntax Error in FindFirst 1/2 of the time

**timesscript** · 07-09-2015, 01:26 PM

I use the following code in an afterupdate to set the record to one chosen in Listbox

[List6]. If the user chooses a valid record in the listbox, it works fine- no errors. However, sometimes the listbox is blank and the user will select the listbox when it's blank. Then I get this error: Run time error 3077: Syntax error (missing operator) in expression.
Any thoughts?

Code:

 Set rs = Me.Recordset.Clone
 rs.FindFirst "[SuspensionID] = " & Me!
[List6]
 If Not rs.EOF Then Me.Bookmark = rs.Bookmark

**pbaldy** · 07-09-2015, 01:36 PM

You can test first:

If Len(Me.List6 & vbNullString) > 0 Then

**timesscript** · 07-09-2015, 01:59 PM

Exactly what I needed Paul, thanks a bunch!

**pbaldy** · 07-09-2015, 02:22 PM

Happy to help!

Syntax Error in FindFirst 1/2 of the time

Thread Tools

Syntax Error in FindFirst 1/2 of the time

Similar Threads

.findFirst 3077 syntax error

Run-time error '3075': Syntax error in string in query expression

INSERT INTO Run-time error 3075 Syntax error (missing operator) in query expression

Run-time Error '3075' - Syntax error (missing operator) in query expression

using FindFirst with a Date Criteria (syntax error)

Posting Permissions