Access 2003 how to activate button after pressing enter on form?

[donbolinger]

We have an Access 2003 form with several fields and a command button which activates a macro to open a query. When you press tab or enter, it cycles through to the next field.

We would like to have it activate the command button when you press enter (so you don't have to go to each field).

Any ideas?

P.S. I'm a VBA rookie...

Thanks!

 

[donbolinger]

Nevermind - I found the answer in the Access Forms thread:

Open the Properties window of the Form.
Select the command button you want.
Change the Default value to Yes.

Whenever Enter is pressed, this command button is activated.

Thanks!