conner
07-19-2007, 07:52 AM
TIA for the help. I will try to provide too much information up front in anticipation of questions.
I have a form for job descriptions. It has a field named Level (fourth in the form) with 6 levels in a dropdown list: Analyst, Consultant, Sr. Consultant, Manager, etc. Based on the value of this field, I need to select one of six Word documents and insert it into a field called cornerstones (located at the endof the form, last field, #17). I can do this, once. The issue is that I recognize that the person completing the form may accidentally tab through the level field and not mean to select the default or may select incorrectly, or we may reuse a base job description, which means the value of cornerstones needs to change.
This is where everything breaks for me. After I have inserted the document into the field, the filed is replaced by the document, and I can no longer clear the contents.
Here is my high level logic:
Determine value of level field
Clear the contents of the cornerstones field
Locate to the cornerstones field
Select the proper document to insert into the cornerstones field
Insert the document into the cornerstones field
Locate to the next field, travel
I have tried this many ways using various incantations of Selection.InsertFile FileName, but nothing works.
Any help will be appreciated (and possibly rewarded with a shirt).
Regards,
Ben
I have a form for job descriptions. It has a field named Level (fourth in the form) with 6 levels in a dropdown list: Analyst, Consultant, Sr. Consultant, Manager, etc. Based on the value of this field, I need to select one of six Word documents and insert it into a field called cornerstones (located at the endof the form, last field, #17). I can do this, once. The issue is that I recognize that the person completing the form may accidentally tab through the level field and not mean to select the default or may select incorrectly, or we may reuse a base job description, which means the value of cornerstones needs to change.
This is where everything breaks for me. After I have inserted the document into the field, the filed is replaced by the document, and I can no longer clear the contents.
Here is my high level logic:
Determine value of level field
Clear the contents of the cornerstones field
Locate to the cornerstones field
Select the proper document to insert into the cornerstones field
Insert the document into the cornerstones field
Locate to the next field, travel
I have tried this many ways using various incantations of Selection.InsertFile FileName, but nothing works.
Any help will be appreciated (and possibly rewarded with a shirt).
Regards,
Ben