changing field on table from Text to Number

[fainterm]

I have a database where one field's data type was defined as Text, but really needs to be changed to Number. I have a query that runs against the table which returns search results based on the input from the user in an unbound text box on a form. When I change the data type, and run my query, Access debugger is stopping on Me.Filter = strWhere Right now I have the field defined like this:

If Not IsNull(Me.txtSearchMRN) Then
strWhere = strWhere & "([MRN] = """ & Me.txtSearchMRN & """) AND "
End If

I believe something needs to be modified here to state that the data type has changed, but I may be way off. What other considerations should I take to ensure that changing the data type doesn't break anything else?

[rpeare]

if you have changed the string to a number in the query you would want:

strWhere = strWhere & "([MRN] = " & Me.txtSearchMRN & ") AND "

[fainterm]

You're the man! Thank you sir.