on last enter start new blank form
in [General]
|
From: JMD.Park on 19 Mar 2010 10:45 is there a way to have a new blank form start after entering last input of information? Thanks in advance for the help!
From: Jeff Boyce on 19 Mar 2010 10:51 If you set the form's property to add new records, and add a <Save> command button, you should get "a new blank form". If you're asking how to have it happen without the <Save> button, how will Access "know" when you're finished entering data? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "JMD.Park" <JMDPark(a)discussions.microsoft.com> wrote in message news:9CE405B9-B422-4996-AD03-1F4D000E2EF9(a)microsoft.com... > is there a way to have a new blank form start after entering last input of > information? Thanks in advance for the help!
From: JMD.Park on 19 Mar 2010 12:23 Last entered would be enter or tab after last field "Jeff Boyce" wrote: > If you set the form's property to add new records, and add a <Save> command > button, you should get "a new blank form". If you're asking how to have it > happen without the <Save> button, how will Access "know" when you're > finished entering data? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "JMD.Park" <JMDPark(a)discussions.microsoft.com> wrote in message > news:9CE405B9-B422-4996-AD03-1F4D000E2EF9(a)microsoft.com... > > is there a way to have a new blank form start after entering last input of > > information? Thanks in advance for the help! > > > . >
From: JMD.Park on 19 Mar 2010 12:24 How would I set the form's property to add new records? and add a save command? "Jeff Boyce" wrote: > If you set the form's property to add new records, and add a <Save> command > button, you should get "a new blank form". If you're asking how to have it > happen without the <Save> button, how will Access "know" when you're > finished entering data? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "JMD.Park" <JMDPark(a)discussions.microsoft.com> wrote in message > news:9CE405B9-B422-4996-AD03-1F4D000E2EF9(a)microsoft.com... > > is there a way to have a new blank form start after entering last input of > > information? Thanks in advance for the help! > > > . >
From: KenSheridan via AccessMonster.com on 19 Mar 2010 12:51
In the AfterUpdate event procedure of the control in question put the following code: DoCmd.GoToRecord acForm, Me.Name, acNewRec This will take you to a blank new record immediately after entering data in the control, whether you've just entered a new record or edited an existing one. But bear in mind that a user might not necessarily enter the data in the controls in the correct order. An alternative would be to make sure that the control is last in the form's tab order, and put the above code in the form's AfterUpdate event procedure rather than the control's. This would mean that the form would move to a new blank record either after entering data in the control, or if after entering data in the control and then moving back to another control with the mouse or Shift-Tab, they then save the record explicitly or by moving off it with the navigation bar. Ken Sheridan Stafford, England JMD.Park wrote: >Last entered would be enter or tab after last field > >> If you set the form's property to add new records, and add a <Save> command >> button, you should get "a new blank form". If you're asking how to have it >[quoted text clipped - 10 lines] >> >> . -- Message posted via http://www.accessmonster.com |