John,

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. 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.

What can I do to prevent the data from being corrupted?

Many Thanks,
Brad.

>Brad ---
>
>OK, what does the main testbox do that would change the value of the other textboxes? Can you explain a bit what you are trying to do?
>
>
>>I did and the other text boxes are not responding. Should I call 911?
>>
>>>
>>>Try putting Refresh code in LostFocus event
>>>
>>>>This may be a very simple thing to answer. I created a form and placed some text boxes on it from the data environment.
>>>>One of the boxes is the "main" box. How do I get the other boxes to acknowledge changes in the main box and have them change to the current record?
>>>>I tried to put Thisform.refresh() in the keypress event of 13 in the main text box, with no success.
>>>>
>>>>
>>>>Thanks, Brad.