Form Event On Enter

[JeffGeorge]

I have a very simple form that consists of a data entry field and a command button. When the command button is clicked a report is called that executes a query based on whatever is entered in the field. I would like to be able to simply hit Enter after typing the data and have it do the same thing. However, when I add the same macro command to this unbound text box as I am using for the command button, nothing happens when I hit Enter. In fact, the related report opens at the same time I open the form and runs the query with no criteria. How can I add functionality similar to the 'click on command button' to this unbound text box?

[Bob Fitz]

Put your code in the After Update event of the text box.

[JeffGeorge]

That worked perfectly; thank you. I thought I had tried that but I had probably just messed everything up by all of the different things I tried. Thanks again.

[Missinglinq]

For future reference, Command Buttons have a property named 'Default.' If you set a Command Button's Default Property to Yes, hitting <Enter> is the same as clicking on the Command Button.

Obviously, only one Command Button per Form can have its Default set to Yes.

To set the Default, in Form Design View

• Select the Command Button
• Go to Properties - Other
• Set Default Property to Yes

Linq ;0)>