Text fields to create drawing numbers

[ImtechJac]

Hi guys,



I'm trying to have my drawing numbers update automatically. I'm trying to use text fields to do this. An example of a drawing number is as follows:



SEW-07636-SS-ELE-00004



I want the user to be able to type the site name into an activeX text box (Site 1, Site 2, etc...), or a drop down combo box and the first half of the drawing number will be populated.

The last 5 digits are to be updated like a page number, which is simple enough... but this number will not always start from one. So I want the user to type the next available number into and activeX box and have the drawing numbers for all the pages of the document to begin at that number.

So for the text field to have a formula along the lines of

=PageNumber() + "value from activeX textbox1"

but i don't know the syntax to achieve this.

I've played about with =ShapeText() but it doesn't seem to get me anywhere.



Could anyone advise on retrieving values from activeX boxes to manipulate with other functions to get to a drawing number.



Thanks in advance



Jac