I have a label for a product that has 20 different part numbers. I created a drop down menu so you can choose the part number to print. It prints the number and also a barcode below it. Some numbers have the same quantity that gets shipped and some have a different number that gets shipped, but the quantity to be shipped is derived from the part number chosen. So I want to display the number to be shipped in another field (location) on the label after I choose my part number. I have been trying to use VB and an IF, Then statement so when a certain part number is chosen, a certain quantity is displayed.
This is hard for me to explain because I am very new to the software and I'm trying to take out as much human error as possible.
Maybe I can explain it better....when I go to print I get prompted with a drop down menu to choose a part number....I choose....it display the part number and a barcode in another field. I want a quantity display in another field based on the part number. Part numbers 0001 - 0005 have a quantity of 20, part numbers 0006-0020 have a quantity of 30. So when I choose 0001, a 20 will be displayed in another field as well as the part number.
Can anyone help me with the Visual basic code or in a different way. I've used the "If" statement in Excel plenty of times, but not sure how it worls in Bartender.