I have three buttons on a form I want one button (cmdFind) to activate
when the enter key is pressed. I have two text boxes that can have
data entered into them.

The three buttons: cmdFind, cmdClear and cmdClose.
The two text boxes: txtPlate and txtModel

I enter a license plate number in a text box or a vehicle model in a
different text box. When I put data into either box and hit enter I
want to activate the cmdFind command button.

Many thanks....the grey cells have failed me!

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=516179

Set the Default property on that button to True.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Craigm" wrote in
message ...

I have three buttons on a form I want one button (cmdFind) to activate
when the enter key is pressed. I have two text boxes that can have
data entered into them.

The three buttons: cmdFind, cmdClear and cmdClose.
The two text boxes: txtPlate and txtModel

I enter a license plate number in a text box or a vehicle model in a
different text box. When I put data into either box and hit enter I
want to activate the cmdFind command button.

Many thanks....the grey cells have failed me!

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile:
http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=516179

Boy do I feel dumb. Thanks for your help. I kept trying to setfocus
and that just was not working at all.

Thanks Again,

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=516179