I'm experiencing an issue with a BarTender document where I'm using a MySQL database as the data source (not from the local computer). In my setup, I have configured a query prompt to filter records based on the "po_number". After each print job, I’ve set this query prompt to update its default value.

Here’s the structure:

• I linked the query prompt to a data entry form where the user selects the "po_number" via a dropdown picker.
• The dropdown picker itself is populated with values pulled from the MySQL database.

The issue: Although this setup works correctly at times, I frequently encounter an odd behavior during print jobs. When a user selects a different "po_number" from the dropdown, the value often reverts back to the previous default value rather than holding the selected value. This only happens occasionally but enough to disrupt the workflow.

Any advice on what might be causing this issue or how to resolve it? I’ve attached a GIF that demonstrates this behavior for reference.

Thanks for your help!