We have a form that our saleman make to request a sample to be made. There are times that we may make 4 samples. Right now they have to retype the information from the last sheet. Is there a way to copy MOST of the info from the underlying (or previous) record? I say most, because I have to change the sample number, color changes, and sample sizes, etc.
Its not a different form. Its the same form, just a different recordset.
Let's see if I can make sense of this! Sorry!!
I have a company, person, sample size, number of samples, list of person doing the samples,phone, etc. let's say on Sample# ADV-102 with Red and Blue as the colors.
When I go to the next recordset I would like to write a macro or write code so I can hit a button to copy the (company, person, sample size, number of samples, list of person doing the samples,phone, etc.) from the previous recordset. Then I can enter a new Sample number ADV-103 and add the new colors say Red and Green
Ok in that case get have two command buttons one for copy and one for past.
Under the copy button write the code
Private sub Copy_Click()
Glo_Field1 = My.Field1
then have a code behind the paste button
My.Field1 = Glo_Field1
*** It may be Me.Field1 I'm not sure.
Not sure how to do this myself but just wondering. If you use that code, how will it know what record you are wanting to copy the data from? I found this online somewhere and if I can find it again I will post it here. Once needed it myself, but then the entire database changed so didn't need it. But I will look. And as said, not being a bad guy, just inquiring, as I too am still learning.