I have a macro where I need to append serial number records to a table. I need to repeat this x number of times based on the value in the Field qty_to_ship of Table ProdOrderQtyToMake. I have to generate serial numbers for labels that start with a value of 0001 and end with the number of qty_to_ship value.
For example, if ProdOrderQtyToMake.qty_to_ship = 375. The serial numbers will be 0001-0375. I need to run the append query 375 times. I have the append query in a macro called mcrAppSerialNumbers.
I cannot figure out the correct syntax to enter into the Repeat Expression of my RunMacro action. I've tried so many things with DLookup and DCount and other ways but nothing works. Can someone tell me how to do this? Please?? (and thank you!)
For example, if ProdOrderQtyToMake.qty_to_ship = 375. The serial numbers will be 0001-0375. I need to run the append query 375 times. I have the append query in a macro called mcrAppSerialNumbers.
I cannot figure out the correct syntax to enter into the Repeat Expression of my RunMacro action. I've tried so many things with DLookup and DCount and other ways but nothing works. Can someone tell me how to do this? Please?? (and thank you!)