Hi Brad ---


No sweat on the confusion...I'm glad it appears to have worked out.

>I am sorry for the confusion on this. I have 5 objects on the form that are OLE to a program called DrDwg that display autocad drawings. What I am doing is referencing the text boxes that are bound to a table, with names of the drawings in it.
>
>When you go to the next record, each object updates with the correct drawing displayed.
>
>What I am doing is letting a user type in the main part number and referencing a table that has the corresponding names of all of the drawings for that part number in it. This allows them to view the drawings on the screen so they can assemble the main part from the many parts that go into it.
>
>The problem I was having was that when I changed records the individual ole names were comming in the text boxes as desired and the drawings were being viewed as planned. HOwever, the ole object was unable to reference the part drawing unless the name in the table had .dwg added to the end of the record. What I am doing is using alltrim(this.value + ".dwg") which would add .dwg to the data and when it would call it up again, it would have the previous ".dwg" already there and it would add it again to the name in the record. This would cause the OLE software not to recognize it as a valid name and not display the drawing on the screen. What I did to correct this is in the activate method of the form, I was place a NOUPDATE on the end of the USE statement, and all is well. The data comes up on the screen, the .dwg is added to allow the OLE to see it and the data is basically in read only mode. (WHEW).
>
>Well, if that doesn't confuse you then nothing else will. I am sorry for the misunderstanding, and thanks for responding to the question.
>