Error 3075

[PatAccess]

Hello,

Here is my code

Private Sub cmdSearchFolder_Click()
DoCmd.OpenForm "FrmSearchByFolder", , , "[FolderID]= & Me.cboFolders.column(0) & "
End Sub

but I get error 3075 Syntax error (missing operator) in query expression...

FolderID is a number cbo and me.cboFolders' first column(0) is numbers as well. What am I doing wrong? :banghead:

 

[vba_php]

Hello,

Here is my code

Private Sub cmdSearchFolder_Click()
DoCmd.OpenForm "FrmSearchByFolder", , , "[FolderID]= & Me.cboFolders.column(0) & "
End Sub

but I get error 3075 Syntax error (missing operator) in query expression...

FolderID is a number cbo and me.cboFolders' first column(0) is numbers as well. What am I doing wrong? :banghead:

probably an extra " double quote at the end. maybe:

"[FolderID]= " & Me.cboFolders.column(0)

 

[PatAccess]

Yes that and

Private Sub cmdSearchFolder_Click()
DoCmd.OpenForm "FrmSearchByFolder", , , "FolderID=" & Me.cboFolders.Column(0) & ""
End Sub

That was pretty easy.
Thanks for the help

 

[isladogs]

The & "" at the end serves no purpose and isn't needed.
If, as is likely, the first column is bound then you don't need Column(0) either.
So this can be simplified further to

Private Sub cmdSearchFolder_Click()
DoCmd.OpenForm "FrmSearchByFolder", , , "FolderID=" & Me.cboFolders
End Sub