Radio Buttons To Select Database Field For Upc-A Using Vb Script 关注
New to BarTender, little to no experience with VB Scripts.
I'm trying to put a label together that will display our stock code, description, lot # and UPC-A code from our Syspro database tables. Label will also include a Data Matrix barcode that returns stock code & lot number and this works fine as is.
We use the same stock code and description for different size box counts that have different UPC-A codes. Our UPC-A codes are in different custom fields tied to the stock code.
I'm trying to have the radio button selection determine the database field to pull from to print the appropriate UPC-A code for the box count. I believe this can be accomplished through VB Script but have been unsuccessful so far.
Here's what I have in my script:
Functions and Subs
'Common subroutines, functions, and variables can be placed here that can be
'referenced by other events.
'Called when the list is populated.
'Use vbCr to separate list items.
'Use vbTab to separate name-value pairs.
Value = "50 Ct Box" + vbTab + Field("InvMaster+.UPC50B") + vbCr + "100 Ct Box" + vbTab + Field("InvMaster+.UPC100B") + vbCr + "250 Ct Box" + vbTab + Field("InvMaster+.UPC250B") + vbCr + "500 Ct Box" + vbTab + Field("InvMaster+.UPC500B") + vbCr + "1000 Ct Box" + vbTab + Field("InvMaster+.UPC1000B") + vbCr + "2000 Ct Box" + vbTab + Field("InvMaster+.UPC2000") + vbCr + "5000 Ct Box" + vbTab + Field("InvMaster+.UPC5000B")
Any help offered is much appreciated.