A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tab Order & form sections



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 05:51 PM
Randy K.
external usenet poster
 
Posts: n/a
Default Tab Order & form sections

I have a form with controls in both the detail and footer section. The form
is set to continuous forms and when the form is opened, focus starts with an
item in the detail section and when the user tabs through, it moves through
the 1 or more detail records until it reaches the last control of the last
detail record. From there, it moves to the first control of the last
record, and I WANT it to move to the first control of the footer section.

What do I need to do/set to have it behave as I/the users want it to?

TIA,
Randy


  #2  
Old August 13th, 2004, 01:18 PM
Stewart Tanner
external usenet poster
 
Posts: n/a
Default Tab Order & form sections

in the oncurrent event of the form do something like this

if me.newrecord then
me.control.setfocus
end if

where control is the name of the first control in the footer.


"Randy K." wrote in message
...
I have a form with controls in both the detail and footer section. The

form
is set to continuous forms and when the form is opened, focus starts with

an
item in the detail section and when the user tabs through, it moves

through
the 1 or more detail records until it reaches the last control of the last
detail record. From there, it moves to the first control of the last
record, and I WANT it to move to the first control of the footer section.

What do I need to do/set to have it behave as I/the users want it to?

TIA,
Randy




  #3  
Old August 26th, 2004, 06:39 PM
Randy K.
external usenet poster
 
Posts: n/a
Default

The subform doesn't allow new records.
It only shows the records returned from a query so it just cycles on the
last record so I don't know what to check for with that method.

TIA,
Randy

"Stewart Tanner" wrote in message
...
in the oncurrent event of the form do something like this

if me.newrecord then
me.control.setfocus
end if

where control is the name of the first control in the footer.


"Randy K." wrote in message
...
I have a form with controls in both the detail and footer section. The

form
is set to continuous forms and when the form is opened, focus starts

with
an
item in the detail section and when the user tabs through, it moves

through
the 1 or more detail records until it reaches the last control of the

last
detail record. From there, it moves to the first control of the last
record, and I WANT it to move to the first control of the footer

section.

What do I need to do/set to have it behave as I/the users want it to?

TIA,
Randy






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help with joining table for an order form to be based on Arleta General Discussion 5 October 5th, 2004 04:33 PM
Default values to load up automatically in a form based on value entered in another form Anthony Dowd Using Forms 8 August 12th, 2004 08:53 AM
Data Dependencies between Combo Boxes Tom Using Forms 7 June 6th, 2004 05:25 PM
Problem adding a command button to a form in order to open another form Janice New Users 2 May 10th, 2004 11:31 PM
Order form Jamie Worksheet Functions 1 September 16th, 2003 11:02 PM


All times are GMT +1. The time now is 08:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.