Populate Labels Based on User Selection in Data Entry Form Follow


Hi, currently, in bartender 2016 R3, I would like to know if we can populate template labels based on user selection in the data entry from Sql database.

Eg: The item code will automatically change when I choose the job no in the dropdown selection, but I also want it to take effect for PO#.

Currently, the system will allow to choose & populate any 1 field, but I’m not sure how to do it for more than 1 field. Is there any way to achieve this using vbscript? Has OnChangeData been implemented in the newer Bartender versions ?

Thank you in advance.


Peter Thane
Comment actions Permalink



If I understand correctly what you are trying to achieve I believe you will need connect the label template to the database and not just the Data Entry From. This assumes that the PO number is linked to the job number in the database.

On the Template itself use the Database Connection Setup to link your label to the database and add a Query/Filter to form the users to use as the lookup. Once linked then you can just add/drag & drop the appropriate database fields onto the label. On you Data Entry form you can then add a Text Input item and link your database filter to that replacing the dropdown list with that  


FYI: I would also suggest updating your version to the last (R9) release of 2016 as there was a malware breach iin R3 see: https://support.seagullscientific.com/hc/en-us/articles/360056321614-BarTender-2016-Malware-Vulnerability


Please sign in to leave a comment.