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 » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Updating values from the previous record



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 06:12 AM posted to microsoft.public.access.queries
leo
external usenet poster
 
Posts: 236
Default Updating values from the previous record

I was using Allen Browne's module to update values from previous record. The
entire code could be viewed at the following address:

http://allenbrowne.com/ser-24.html

It updates every field. You can exclude the fields that you
don't want to be updated by naming them in the before insert event of the
form. When the forms have too many controls
(Yes I know it is a bad idea to have that many in one form!) and only a few
need to be carried over, I did not want to have a unmanageably long list
of controls to be excluded. At the suggestion of "BruceM" I did the
following as he suggested:
If Not bSkip Then
to:
If bSkip Then

And then I did not do anything further with the codes in the module. But as
the
codes are intended, in the before insert event of the form I named in the
exclusion list all the controls that I wanted to be included! It worked like
a charm!

Now the question: Does anyone foresee any problem down the line.

Any help will be appreciated

Thanking you
Sincerely
Leo

 




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


All times are GMT +1. The time now is 03:28 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.