We do floor systems. We make samples for customers with different colors.
Many times we make 3 or 4 samples at a time. Is there a way I can copy all the data I just entered onto the next form? I don't want the colors to go to the new page, just the main information, like Customer, Name, Sample Number, Size of Sample, etc. etc.
I know I can type Ctrl ' in each cell, but it would be more convenient to just copy all the data from the main form to the next new form.
Depending on how exactly you want the work flow to go I could think of several ways to accomplish this.
Easiest way seems to be to use a main form and a subform. Have the information you want to keep in the main and the sample information in the sub.
I am sorry I guess i need more caffiene but I am uncertain what the problem is. It sounds like you a main form with the information you wish to keep and a subform that has the information that changes.
Is this correct ?
If so why not go to a new record in the subform? You can put the sample ID in the subform also.
For the sample ID take off the numbers use VB to add 1 to the ID.
Have a button "Make another sample for this customer" and ONClick does a form refresh on the subform.
There are many other ways to accomplish the same task.
I have attached the file so you can see what I am talking about
Go back to BIO-213 the last record. I would like all information of BIO-213 to go a new record (Not the colors in the subform). Where I am in the SampleNumber control BIO-213, I will change it manually to 214, no problem. I just want all the same information to go to the next record.