Brad ---
I am way way confused on your use of textboxes and what you are trying to accomplish. Perhaps you can clarify a bit for me.
>I was able to talk to someone on this issue and unbound my text box to the control source, then used the seek command to search the table for the records.
>
>However, now I have a different problem. I am using a OLE that needs to have a default ".dwg" added to the text before It will update the screen with an autocad file. Each one of the text boxes represent a drawing done in autocad and the ole reads the box and opens the corresponding file in the ole object.
OK, so the textbox represents a filename that you are passing to an ActiveX object?
>My problem is that the text boxes are bound to the table now and when I bring them into the text box it adds the .dwg on the end of the file name and then writes it to the table. This corrupts my data. I tried to make sure to use the noupdata on the form activate event, and even made the text boxes read only, I also went into the data environment and made the table readonly.
>
So...what you're saying is that a binary object is getting bound to the textbox and, subsequently, into the table --- blowing up your values?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05