>>>I've got two edit boxes on this form. The form was made with a wizard and I think both of these edit boxes were made with the form (as opposed to the combo boxes on the form which I had to add later). Both of them are tied to fields in a view which is based on a remote table (Access, if that matters). One of them works perfectly. I click "edit", put in data and it goes into the table and everything's beautiful. With the other one, I click edit and change the data in the edit box and when I click "save" it goes back to the data it had there before. Changes not "taking".
>>>
>>>I got so fed up with looking at the properties of the misbehaving editbox that I deleted it and copied the other one to that spot on the form. I changed the control source from viewencumb.rush_reason to viewencumb.desc and changed the name of the editbox but left everything else the same. I figured since this one worked, I'd just make these couple of changes and everything would be fine. No luck.... it's still not updating my table.
>>>
>>>I checked the view and they both have the checkmark in the update column (I guess that's the one with the little pencil above it) and the view itself has "send sql updates" checked. I checked the Access table and can see no difference between the two fields.
>>>
>>>I'm completely lost. Could someone please help me with some idea of what else to look for? I would certainly appreciate it.


Hi Denise,

You may want to take a look at the order methods are firing in. I encountered a similar problem with a grid, and found the problem in the order that methods were firing.

Just a thought.

Regards,

Jason