If then
Our labels are set up to populate several fields using a selection from a database. There are then other fields that are filled in by the user. I would like to be able to partially populate a field based on the selection from the database. The remaining portion of the same field would then be filled in by the user.
I am relatively new to VBscripting. I have done some basic math, but nothing this advanced. I have however, performed similar operations in other programs using javascripting.
Any help would be greatly appreciated.
-
Hi Shannon,
Have you tried making the part database part manual field two separate sub-strings with each having a different source?
Go into the Properties of the field on the label and click on the Data Source at the bottom of the column on the left hand side.
At the bottom of the pane with the column will be a number of buttons and you need to click on the New Data Source button to add on a second sub-string and then configure this to pick up the data from your database field. Then use the UP arrow button to make the database string the 1st one in the label field.
I hope this helps
Pete
0 -
That will work. However, I would like to find a way for the part that would come from the first sub-string (database part) to appear in the text entry field so that that information does not show up on the label twice (once from the database, then again from the operator entering the same information).
0 -
On your Data Entry form add a separate entry field for each element but make the Database one Read Only so the users cant change it but can see the value on the screen and then for the second sub-string ask them to only enter the manual part.
0
Please sign in to leave a comment.
Comments
3 comments