I am sure there is an easy way to do this but I have exhausted all avenues.
I have some label data in a table which I want to copy to an identical table. However the first label I may only want one of that label data copying to the new table. The second label I may want seven of that label data copying to the new table. I have a count field called "nooflabels"! which has 1 in the first record and 7 in the second.
I have created an append query and set up a macro to run then created a button in my form to run that macro
Expand|Select|Wrap|Line Numbers
- Dim thecount As Integer
- Dim stDocName As String
- thecount = Me.Nooflabels
- stDocName = "Create_duplicatedespatches"
- DoCmd.RunMacro stDocName, thecount
How can I split this out.
Am feel I am going down the wrong track and wondering if I should be using loop although i have never used this before.
Please could someone advice on this.
Thanks
jacc14