Can't apply filter on form from comboBox - run-time error 3075

[jzeig1]

Not sure if this is the rite section / page to post this but here goes.
I am trying to figure out what is the best method of (1) either change the underlining RecordSource of the forms data or (2) should I use the filter property to goto record
The form consist of a main for with member: firstName, lastName, middleName. I also have a combobox with mbr_ID and Name: [mbr_LastName] & ", " & [mbr_FirstName].
I've tried a couple of ways to do it, but keep getting errors. The current method is something like this:

Dim StrMemNam as String
strMemNam = "SELECT tblMembers.*, tblMembers.[mbr_ID] FROM tblMembers WHERE (((tblMembers.[mbr_ID])='" & Nz(Me.cmbMemNam.Column(0)) & "'));" Me.Filter = strMemNam
Me.FilterOn = True
Syntex error in query expression 'Select tblMembers.*,tblMembers[mbr_ID] FROM tblMembers WHERE (((tblMembers.[mbr_ID])='123'));'.

Humm, the more I learn the harder this gets

[Bob Fitz]

The Filter expression only needs to be the "WHERE" part of the "SELECT" statement without the "WHERE", so yours should be something like:

(tblMembers.[mbr_ID])='" & Nz(Me.cmbMemNam.Column(0)) & "'

However, if "mbr_ID" is a number field rather that a text field then the quote marks used as delimiters are not needed, so perhaps you need something like:

"tblMembers.[mbr_ID]= Nz(Me.cmbMemNam.Column(0))"

[jzeig1]

OK, so here's where we stand.
Private Sub cmbMemNam_AfterUpdate()
Dim strMemNam As String
strMemNam = "tblMembers.[mbr_ID] = Nz(Me.cmbMemNam.Column(0))"
Me.Filter = strMemNam
Me.FilterOn = True
End Sub

The "Me.Filter = strMemNam" evaluates to MeFilter = strMemNam = True; which doesn't make much sence to me.
And Me.Filter = True

The error comes back as Run-time error '3085' Undefined function 'Me.cmbMemNam.Column' in expression.

btw: thanks

[andy49]

This line isn't right

strMemNam = "tblMembers.[mbr_ID] = Nz(Me.cmbMemNam.Column(0))"

Something like

strMemNam = "tblMembers.[mbr_ID] = " & Nz(Me.cmbMemNam.Column(0))

[jzeig1]

@andy49 Thanks. That did the trick. ;-)