Greetings!
What I am looking for is help trying to accomplish control + tab
exiting subform #1 on page #1 and entering the first control (main
form) on page #2. I've tried the following code, however it seems to
"fire twice", placing me at the first control on subform #2 on page
#3, totally skipping page #2. It seems to very briefly stop the
control on page two, but keeps going. Hope that made sense. Key
preview for subform is set to yes. This is a continous subform, so
options to leave subform on last control won't work. That's why I'm
trying to use control tab. I'd appreciate any suggestions.
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyTab And Shift = 2 Then
DoCmd.GoToControl "txtZoningClass+"
End If
End Sub 2 1504
The problem is probably that you did not assign KeyCode = 0 in your handler.
Thus, after your code runs, the keypress is also processed normally.
On 13 Sep 2004 11:39:22 -0700, br************@ci.verona.wi.us (Brian) wrote: Greetings! What I am looking for is help trying to accomplish control + tab exiting subform #1 on page #1 and entering the first control (main form) on page #2. I've tried the following code, however it seems to "fire twice", placing me at the first control on subform #2 on page #3, totally skipping page #2. It seems to very briefly stop the control on page two, but keeps going. Hope that made sense. Key preview for subform is set to yes. This is a continous subform, so options to leave subform on last control won't work. That's why I'm trying to use control tab. I'd appreciate any suggestions.
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyTab And Shift = 2 Then
DoCmd.GoToControl "txtZoningClass+"
End If
End Sub
Thanks, Steve.....that did it. Appreciate the help!!!
Steve Jorgensen <no****@nospam.nospam> wrote in message news:<j5********************************@4ax.com>. .. The problem is probably that you did not assign KeyCode = 0 in your handler. Thus, after your code runs, the keypress is also processed normally.
On 13 Sep 2004 11:39:22 -0700, br************@ci.verona.wi.us (Brian) wrote:
Greetings! What I am looking for is help trying to accomplish control + tab exiting subform #1 on page #1 and entering the first control (main form) on page #2. I've tried the following code, however it seems to "fire twice", placing me at the first control on subform #2 on page #3, totally skipping page #2. It seems to very briefly stop the control on page two, but keeps going. Hope that made sense. Key preview for subform is set to yes. This is a continous subform, so options to leave subform on last control won't work. That's why I'm trying to use control tab. I'd appreciate any suggestions.
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyTab And Shift = 2 Then
DoCmd.GoToControl "txtZoningClass+"
End If
End Sub This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Not Me |
last post by:
Hi,
Just trying to get my head around tab controls, is there anywhere which
would describe the structure of how they work? I seem to be ok so far,
being able to check which page I'm on etc......
|
by: misscrf |
last post by:
I have an entry form which has a tab control. If print screens are
needed, please let me know and I will prepare them and post them.
Anyway, this tab control has 3 pages. When I am on one of the...
|
by: robert.waters |
last post by:
Hello,
If I have a form containing a Tab Control with N pages, each page
containing a subform, are those subforms loaded into memory when
another page has the focus? I have tried iterating...
|
by: ApexData |
last post by:
I am using the following code in my TabControl to manage subform
loads. The code assigns the subForms SourceObject.
- Do I also need code to DeAssign the SourceObject when leaving the
Tab, I'm...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |