Hi
I've entered what you've shown above and it comes up with a parameter box which asks me to re-enter each part of the number.

The type of number i'm searching is actually a series of numbers and letters with dashes, eg XXX-YYY-ZZZ. The parameter box then shows "enter parameter value XXX" then "enter parameter value YYY" etc. Final after I've clicked through the boxes, an error message comes up saying that...

Hi

I'm a complete newbie to Access but work have asked me to create a form on my database which will allow all users to search in a box in a split form, and relevant records appear in the lower screen. I'm working in Access 2007.

I have a text box at the moment for users to type their number into (document number, etc) with a macro button to search. The code for the button is:

...