Populating Label After Entering 1 Piece of Information
I have a label with multiple fields that are coming from a database:
I also have a userform that is asking for the Reel ID and Qty:
The goal is that when a user enters in the Reel ID into the userform, this will search the database, and pull the reel ID row and populate the fields in the label template, except the quantity. I have been searching online for how to pull the 1 row of data, and I know it has to do with a query, but there is still something missing where the rest of the template doesn't fill in.
-
If I understand what you are asking for, if you have set the filter/query in your database then when you access the properties of your data entry input you will see the filter listed in the selectable items in the Linked Data Source tab.
0 -
Hi Peter,
I am actually looking for it to automatically populate. I do not want to leave it up for error.
So once an operator types in the Reel ID, it would find that ID number and fill in the information from that row, into the label template.
Thank you
0 -
As long as your database contains all the data in a linear format, such as
then that wont be a problem.
- Connect the label to your database
- Configure your Filter/Query so that this prompts the user to type (or even scan) in the Reel ID
- Make each field on the label with data that is in the database and needs to be printed a Database type and link them to the required field from the dropdown or else just drag the field from the column on the left onto the label
0
Please sign in to leave a comment.
Comments
3 comments