I have a querie that links to data in a table. It pulls back 5 different values from the data. Then I have entered an expression called [Customer Number]. I have built it so that it says [Customer] = [Customer Number]. What this does when it is opened is promts the user to enter a value and then pulls back the record where [Customer] is equal to what ever the user put in....

Now the problem is that when it is opened and the user is prompted to enter a value they are prompted to do this through a pop up box!!! I want to get rid of that and have a field on it where they can put in the value and click on a button for it to pull back the relevant records!!!

Is this possible? and if so how do i do it?

Thanks for any help guys and girls!!!

If I understand your question correctly, you want something similar to a combo box to pull up existing records that match your entry. You can search the archives here for numerous posts regarding that, or just allow the combo box wizard to build the code for you. Select the third option 'Find a record based on the value I selected'. It doesn't matter if you end up using this or not (though if you design the rowsource correctly, you can and avoid the use of a command button), or just transfer the code behind a command button beside a text box.

HTH,
David R