 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / March 2005How to duplicate records
I need to carry over information from one to another record, previously enter. I would like to code an Command Button [Add] . Everytime the use click add some info from the previous record is carried over. Why not just set the Default Value so that whatever the last value in a field was, becomes the Default Value entered for a New record. Let's say you have a field called City. Try this code... Private Sub City_AfterUpdate() City.DefaultValue = "'" & ADDR2 & "'" ' that's a single quote within doubles... End Sub If you enter Boston in City, then the next New record will have Boston as enetered as the Default. If you later eneter New York, then from then on, all new records will have New York as the default.. etc etc. hth Al Camp >I need to carry over information from one to another record, previously >enter. > > I would like to code an Command Button [Add] . Everytime the use click > add > some info from the previous record is carried over. hi, say i have a form on which my field's name is "Patient Number", using your approach what would i do. i guess i don't quite understand how you have a field called "City" into which you clone or duplicate "'" & ADDR2 & "'" -- where did you get that ADDR2 from? > Why not just set the Default Value so that whatever the last value in a > field was, becomes the Default Value entered for a New record. [quoted text clipped - 16 lines] > > add > > some info from the previous record is carried over. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.