Label Fields Not Updating From Database On Print Preview 关注
I have a label with a data entry form. Data is read from a database (XLS file). The data entry form is configured with a dropdown field for selecting the primary/unique field in the table and a label preview (image).
The dropdown field options/values on the data entry form are populated with a VB script as explained here: http://forums.seagullscientific.com/index.php?/topic/2446-drop-down-menu-and-vb-script/?p=8060
The label contains a text fields (text field 1) which display the value selected on the dropdown field on the data form, plus an additional text field (text field 2) which should display values corresponding to the dropdown value selected (from the XLS file).
Now, my problem is that, when printing, the label preview on the data form does not update correctly: text field 1 displays the correct value (same value as selected on the dropdown field), but text field 2 is not updating to display the value corresponding to the dropdown field selected, it always shows the value from the first row in the XLS file.
How am I supposed to link text field 2 to the dropdown field selection, so that text field 2 updates with the value corresponding to the dropdown value selected?
When designing the label (non print/preview mode), I can browse through the records with the arrows at the bottom of the screen, and both text field 1 and text field 2 are updating correctly.