Trap for enter...

[john]

In a form I'm trying to make a search field to be able to quickly find a
record on ID-number. User enters a number and presses enter to move to that
record. How do I trap for the enter-keystroke and where should I put the
code?
I found this:
You can set the form's KeyPreview property to YES, then in the Form's
KeyPress event, add the following pseudo-code:
Select Case KeyAscii
Case 13
Select Case Screen.Previous Control.Name
Case "cboMyCombo "
cmdMyButton_Cli ck
End Select
End Select
but I wondered if there is a way to code this inside of the searchfield?
Also, if I have to use the above code where can I find the KeyPreview
property?
Thanks in advance,
john

[Rick Brandt]

john wrote:

In a form I'm trying to make a search field to be able to quickly
find a record on ID-number. User enters a number and presses enter to
move to that record. How do I trap for the enter-keystroke and where
should I put the code?
I found this:
You can set the form's KeyPreview property to YES, then in the Form's
KeyPress event, add the following pseudo-code:
Select Case KeyAscii
Case 13
Select Case Screen.Previous Control.Name
Case "cboMyCombo "
cmdMyButton_Cli ck
End Select
End Select
but I wondered if there is a way to code this inside of the
searchfield? Also, if I have to use the above code where can I find
the KeyPreview property?
Thanks in advance,
john

Put your code in the click event of a button and set the Default property of the
button to true. That will make the click event of the button run when you press
<Enter>. You can make the button transparent if you don't want it to be
visible.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[john]

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:JE******** *********@newss vr29.news.prodi gy.net...

john wrote:

>In a form I'm trying to make a search field to be able to quickly
find a record on ID-number. User enters a number and presses enter to
move to that record. How do I trap for the enter-keystroke and where
should I put the code?
I found this:
You can set the form's KeyPreview property to YES, then in the Form's
KeyPress event, add the following pseudo-code:
Select Case KeyAscii
Case 13
Select Case Screen.Previous Control.Name
Case "cboMyCombo "
cmdMyButton_Cli ck
End Select
End Select
but I wondered if there is a way to code this inside of the
searchfield? Also, if I have to use the above code where can I find
the KeyPreview property?
Thanks in advance,
john

Put your code in the click event of a button and set the Default property
of the button to true. That will make the click event of the button run
when you press <Enter>. You can make the button transparent if you don't
want it to be visible.

Thanks Rick. I partly got it working. The enter is 'recognized' but I have
to press enter twice to execute the button. With the first enter the button
gets focus (coming from the searchfield) and with the second enter the
button is actually pressed. Any idea to resolve that?
john

[Rick Brandt]

john wrote:

Thanks Rick. I partly got it working. The enter is 'recognized' but I
have to press enter twice to execute the button. With the first enter
the button gets focus (coming from the searchfield) and with the
second enter the button is actually pressed. Any idea to resolve that?
john

Then you still have something wrong. The <Enterkey will run ANY button when
that button has focus. The whole point of the Default property is to make a
button run from anywhere in the form by pressing <Enter>.

I'll run a few tests and post back.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Rick Brandt]

Rick Brandt wrote:

john wrote:

Thanks Rick. I partly got it working. The enter is 'recognized' but
I have to press enter twice to execute the button. With the first
enter the button gets focus (coming from the searchfield) and with
the second enter the button is actually pressed. Any idea to
resolve that? john

Then you still have something wrong. The <Enterkey will run ANY
button when that button has focus. The whole point of the Default
property is to make a button run from anywhere in the form by
pressing <Enter>.
I'll run a few tests and post back.

In my tests the button ran on the first <Enterpress no matter where I was in
the form and afterwards the button had focus. This was on a form with many
controls. I then built one like yours that had only a TextBox and a Button and
it still worked with a single <Enterpress.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[john]

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:Ir******** **********@news svr21.news.prod igy.com...

Rick Brandt wrote:

>john wrote:

Thanks Rick. I partly got it working. The enter is 'recognized' but
I have to press enter twice to execute the button. With the first
enter the button gets focus (coming from the searchfield) and with
the second enter the button is actually pressed. Any idea to
resolve that? john

Then you still have something wrong. The <Enterkey will run ANY
button when that button has focus. The whole point of the Default
property is to make a button run from anywhere in the form by
pressing <Enter>.
I'll run a few tests and post back.

In my tests the button ran on the first <Enterpress no matter where I
was in the form and afterwards the button had focus. This was on a form
with many controls. I then built one like yours that had only a TextBox
and a Button and it still worked with a single <Enterpress.

Thanks Rick. I got it working by putting the code in the button's OnFocus
event. Apart from that I can't figure out why the click event is only
triggered when I hit the enter key for the second time, which is different
from what you describe.
john

[Rick Brandt]

john wrote:

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:Ir******** **********@news svr21.news.prod igy.com...

Rick Brandt wrote:

john wrote:
Thanks Rick. I partly got it working. The enter is 'recognized'
but I have to press enter twice to execute the button. With the
first enter the button gets focus (coming from the searchfield)
and with the second enter the button is actually pressed. Any
idea to resolve that? john
>
Then you still have something wrong. The <Enterkey will run ANY
button when that button has focus. The whole point of the Default
property is to make a button run from anywhere in the form by
pressing <Enter>.
I'll run a few tests and post back.

In my tests the button ran on the first <Enterpress no matter
where I was in the form and afterwards the button had focus. This
was on a form with many controls. I then built one like yours that
had only a TextBox and a Button and it still worked with a single
<Enterpress.

Thanks Rick. I got it working by putting the code in the button's
OnFocus event. Apart from that I can't figure out why the click event
is only triggered when I hit the enter key for the second time, which
is different from what you describe.
john

You did set the Default property of the button to True correct? This property
is found on the { Other } tab of the property sheet.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[john]

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:cc******** **********@news svr21.news.prod igy.com...

john wrote:

>"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:Ir******* ***********@new ssvr21.news.pro digy.com...

Rick Brandt wrote:
john wrote:
Thanks Rick. I partly got it working. The enter is 'recognized'
but I have to press enter twice to execute the button. With the
first enter the button gets focus (coming from the searchfield)
and with the second enter the button is actually pressed. Any
idea to resolve that? john

Then you still have something wrong. The <Enterkey will run ANY
button when that button has focus. The whole point of the Default
property is to make a button run from anywhere in the form by
pressing <Enter>.
I'll run a few tests and post back.

In my tests the button ran on the first <Enterpress no matter
where I was in the form and afterwards the button had focus. This
was on a form with many controls. I then built one like yours that
had only a TextBox and a Button and it still worked with a single
<Enterpress.

Thanks Rick. I got it working by putting the code in the button's
OnFocus event. Apart from that I can't figure out why the click event
is only triggered when I hit the enter key for the second time, which
is different from what you describe.
john

You did set the Default property of the button to True correct? This
property is found on the { Other } tab of the property sheet.

Sorry. I was so sure it was set to True but I must have switched it back to
False while testing. Now it's working like you described.
Thanks for your time...
john

[tina]

have you tried just running the Find code directly from the "search"
control's AfterUpdate event procedure?

hth
"john" <jo**@test.comw rote in message
news:f_******** *************** *******@casema. nl...

In a form I'm trying to make a search field to be able to quickly find a
record on ID-number. User enters a number and presses enter to move to

that

record. How do I trap for the enter-keystroke and where should I put the
code?
I found this:
You can set the form's KeyPreview property to YES, then in the Form's
KeyPress event, add the following pseudo-code:
Select Case KeyAscii
Case 13
Select Case Screen.Previous Control.Name
Case "cboMyCombo "
cmdMyButton_Cli ck
End Select
End Select
but I wondered if there is a way to code this inside of the searchfield?
Also, if I have to use the above code where can I find the KeyPreview
property?
Thanks in advance,
john

[john]

Thanks, that works, but when user enters a wrong number and hits enter the
focus goes to the next field while I would like it to remain focused on the
search field. The same accounts for when a user doesn't update the field and
hits enter.
john

tina" <no****@address .comschreef in bericht
news:61******** ***********@bgt nsc04-news.ops.worldn et.att.net...

have you tried just running the Find code directly from the "search"
control's AfterUpdate event procedure?

hth
"john" <jo**@test.comw rote in message
news:f_******** *************** *******@casema. nl...

>In a form I'm trying to make a search field to be able to quickly find a
record on ID-number. User enters a number and presses enter to move to

that

>record. How do I trap for the enter-keystroke and where should I put the
code?
I found this:
You can set the form's KeyPreview property to YES, then in the Form's
KeyPress event, add the following pseudo-code:
Select Case KeyAscii
Case 13
Select Case Screen.Previous Control.Name
Case "cboMyCombo "
cmdMyButton_Cli ck
End Select
End Select
but I wondered if there is a way to code this inside of the searchfield?
Also, if I have to use the above code where can I find the KeyPreview
property?
Thanks in advance,
john