Conditional printing expressions - can I make them change depending on the database connected? Follow
I am using BarTender to print medical device labels, and I am using conditional printing to print symbols based on a field in a Access database query. I have several queries that are identical and are used interchangeably. My label files can switch to any of the queries and pull data from them without changing the label file. However, the conditional print expression stays locked to the original query used when the label was made. Is there a way for the conditional print expression to automatically change when I connect to different queries?
For example, I have 3 identical queries below.
Label_query1, Label_query2, Label_query3
The "Print when" statement for my symbol is [Label_query1.printsymbol1]="yes". If I connect to Label_query2 using the Database Connection Setup (by choosing another query), I want the "Print when" statement to automatically change to [Label_query2.printsymbol1]="yes". The other data on the label pulls automatically from the query I connect to.
Thanks for any assistance,
Please sign in to leave a comment.