Hiya,

I'm workin on a database with a order list. I want to let the user type in a order number via a text box then just press return to find the relevant order.

I can do it with a button next to the search text box but I want to start the search when the user presses enter. I've tried the Keypress events but they don't seem to work too well.

Anyone done this?

Try the OnEnter for the textbox

Sal

If you use the textboxe's AfterUpdate event pressing either the Enter key or the Tab key will execute your search.

Bob

Thanks Guys. I'll try the after update event again.

Sally, The on Enter event will only work when starting to enter the Order number. I need to to extract the number when the user has finished with it. (I'll try it too though, just in case!)

Cheers
John

Hi, The AfterUpdate event works a treat.

Don't know why I didn't get it working before!

Cheers
J