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  

hotkey to next record



 
 
Thread Tools Display Modes
  #1  
Old December 31st, 2005, 10:43 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

I want to be able to go to the next record using the keyboard. How is this
done?

TIA


  #2  
Old December 31st, 2005, 11:22 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

The answer depends on your screen. If you are in datasheet or tabular
view, the down arrow key will work for you. If you are in a form
showing just a single record, PgDn will do it. Be aware that you will
move to a new record in the field that you were in when you pressed the
key.

hth-

Betsy

  #3  
Old January 1st, 2006, 12:48 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

It is a form|subform. I want to advance the form from the subform
(customerrders) after finishing an order for a customer. hotkey -- next
customer.

ArrowKeys, PgDn does not work. No combination of shift,alt or ctl helps
either. Haven't been able to find info either.


wrote in message
oups.com...
The answer depends on your screen. If you are in datasheet or tabular
view, the down arrow key will work for you. If you are in a form
showing just a single record, PgDn will do it. Be aware that you will
move to a new record in the field that you were in when you pressed the
key.

hth-

Betsy



  #4  
Old January 1st, 2006, 01:16 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

Try Ctrl-Tab to return to the customer form. Then use PgDn.

Betsy

  #5  
Old January 1st, 2006, 05:48 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

Yes that did the trick thanks...


wrote in message
oups.com...
Try Ctrl-Tab to return to the customer form. Then use PgDn.

Betsy



  #6  
Old January 1st, 2006, 11:55 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default hotkey to next record

Another trick is to put a command button on your main form to go to the new
record. Set its Caption property to (say):
&New Record

Now Alt+N takes you to a new record in the main form, even if you are in the
subform.

The button's event procedure would be something like this:
If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doco" wrote in message
.. .
Yes that did the trick thanks...


wrote in message
oups.com...
Try Ctrl-Tab to return to the customer form. Then use PgDn.

Betsy



 




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
Changes record when current is saved Matt Sonic Using Forms 0 December 21st, 2005 05:56 PM
Last (blank) record on form will not delete! [email protected] General Discussion 2 December 16th, 2005 06:16 PM
Next Record keeps making new record even if nothing entered on for Groucho Using Forms 4 November 1st, 2005 12:49 AM
Access and appending records rmoritzky General Discussion 2 October 20th, 2005 11:58 AM
Copy/Paste Record Problem Rob Parker Using Forms 4 May 12th, 2005 09:24 AM


All times are GMT +1. The time now is 12:48 PM.


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