I have a form that has about 4 or 5 text boxes, wich i use to search my tables. I do this by typing in the data and the clicking in the seach button. what i want to do is when i press CR i want it to do the same thing

Use the same code that is behind the button, but put it as an After Update event for your last text box.

I did this, but it goes through all the boxes before it performs the action. Sometimes not all the boxes are filled out.