Roman,
Have you looked at TableUpdate() and TableRevert()? Are you using parameterized views for the records in the grid?
>Ok., I got the typical parent-child form, where you can find a grid for the child records And textboxes for the parent records. I don't like edit/mode forms (they are confusing and a waste of time for the users). I like that all the fields are available for the user at Any moment.
>My problem is this: let's say I put the focus on one of the textboxes of the grid, I guess that mean that I'm selecting the recordsource of the grid or selecting the controlsource of the textbox. Next we click the reverting button , at this point we could expect to revert the record We just left in the grid, but it doesn't happen, it’s like the parent table gets selected as we leave the grid, leaving me with the chance to only revert, delete
>Or save records that belong to the parent table. I find this very confusing and illogicaL, so far I haven't been able to find a solution, what am I doing wrong? I'd like a generic Way to solve this, a solution that selects the right table no matter how many tables we got in the form or whether they have a relation or not.