Modules & VBA :: Searching For Partial Primary Key?

I am trying to search for a partial number in the primary key field. I have based my search off Allen Browne's search form [URL]

I have posted my full code below. I am having trouble with the portion searching the Member_ID field.

My first version:

I would get a Run-time error '3464':

Data type mismatch in criteria expression.

Code:
If Not IsNull(Me.txtMember_ID) Then
strWhere = strWhere & "([Member_ID] = """ & Me.txtMember_ID & """) AND "
End If

My second Version: (I was searching for 54)

I would get a Run-time error '3075'

Syntax error (missing operator) in query expression '([Member_ID] = Like "*54*")'

Code:
If Not IsNull(Me.txtMember_ID) Then
strWhere = strWhere & "([Member_ID] = Like ""*" & Me.txtMember_ID & "*"") AND "
End If

Version 3:

If I use this the search works when the Member_ID matches exactly

Code:
If Not IsNull(Me.txtMember_ID) Then
strWhere = strWhere & "([Member_ID] = " & Me.txtMember_ID & ") AND "
End If

Code:
Private Sub Member_Search_Click()
'Purpose: Build up the criteria string form the non-blank search boxes, and apply to the form's Filter.
'Notes: 1. We tack " AND " on the end of each condition so you can easily add more search boxes; _
we remove the trailing " AND " at the end.
' 2. The date range works like this: _
Both dates = only dates between (both inclusive. _
Start date only = all dates from this one onwards; _
End date only = all dates up to (and including this one).

[code]....