Unbound search filed for numbers

[mickelingon]

Hi

Is there anyone who knows how to help me with this matter.
I have a form that I can search for first and last name in.
But when I try to do the same with the field for Social sequrity number I don't get it to work.
Can anyone have a look at this attached zip database and help me?
Sorry for the social sequrity number beeing named "personnummer" (it's in swedish.

//Mikael

 

[ansentry]

Here is your db back and it is working (searching the PN's)

You did not have an unbound text box for the searching of PN's
Added a unbound text box for searching PN's (txtSearchPN)
Added Input mask to txtSearchPN
Added to source query;

Like [Forms]![Searchaddress_form]![txtSearchPN] & "*"

I have added a button to clear all the data from the unbound text boxes and then show all records.
I put the "Requery" command button there for testing only.
I have tested it and it seems to be working fine.

 

[mickelingon]

thanks alot, that will do it!!

Mikael