OnDirty....SetFocus

[Anthony Hendrata]

Hello All,

I know this may be easy for some people, but I need some help on a
little programming. I have this application that has been developed in
Access, there is a textbox call FindByName and a command button called
cmdFilter. What I would like to do is that when a user begins typing in
the textbox, that the focus would be on the command button. Then when
they hit the enter key it will hit the command button. If you guys
could help me out that would be super fantastic!

Thx

Tony

[Salad]

Anthony Hendrata wrote:

Hello All,

I know this may be easy for some people, but I need some help on a
little programming. I have this application that has been developed in
Access, there is a textbox call FindByName and a command button called
cmdFilter. What I would like to do is that when a user begins typing in
the textbox, that the focus would be on the command button. Then when
they hit the enter key it will hit the command button. If you guys
could help me out that would be super fantastic!

Thx

Tony

Don't know if this will work, but in the text box's OnKeyDown enter
something like
If KeyCode = 13 And Shift = 0 then
cmdFilter_AfterUpdate
Endif

I will assume the afterupdate event for the command button is called
"cmdFilter_AfterUpdate"

[Patrick Fisher]

If I understand what you want then make sure that the command button
is next in the Tab Order after the Text Box, you can if you wish set
the focus explicitly by entering CommandButton.SetFocus in
the After Update propery of the text box.
Patrick

On 20 May 2005 13:45:48 -0700, "Anthony Hendrata"
<an**************@gmail.com> wrote:

Hello All,

I know this may be easy for some people, but I need some help on a
little programming. I have this application that has been developed in
Access, there is a textbox call FindByName and a command button called
cmdFilter. What I would like to do is that when a user begins typing in
the textbox, that the focus would be on the command button. Then when
they hit the enter key it will hit the command button. If you guys
could help me out that would be super fantastic!

Thx

Tony

[Anthony Hendrata]

Hey Patrick,

Getting real close now, thanks for the help. Is there a way so that the
user will not have to hit the ENTER key twice? Once the user enters the
name and then hits the ENTER key, the focus is then put on the command
button. Then the user has to hit the ENTER key one more time. Is there
a way to just let the user hit ENTER once? Thanks alot for the help so
far!

[Chuck Grimsby]

Should be:

If KeyCode = 13 And Shift = 0 then
Call cmdFilter_Click
Endif

[Salad]

Chuck Grimsby wrote:

Should be:

If KeyCode = 13 And Shift = 0 then
Call cmdFilter_Click
Endif

Good catch.

[Jim M]

How about a simpler way to do it?

Open the field's property sheet. Go to the "AfterUpdate" event. If the
Command Button has code in it, put the same code as the [Event
Procedure] for the "AfterUpdate" event. If the command button calls a
Macro, then put the same Macro name in the "AfterUpdate" event.

This will run the command without the user doing anything except
hitting ENTER. It will only do this if the user changes the contents in
the field.

Good luck!
Jim

[Anthony Hendrata]

Beautiful Chuck...works great!! Thanks alot!