>Hello all
>
>I'm posting this to possibly save me a load of experimenting and having to find things out the hard was, i.e. I don't want to re-invent the wheel.
>
>I've never allowed add/delete/edit of records in a grid before as there's never been the need, and I think it's messy and dodgy. I'm remaking an old DOS system and need to emulate the wauy the users are used to, adding records in the "many" table, via a grid, on a separate page from the "one" table, in a one-to-many reln.
>
>Now, if they're editing recs in the grid, then OK, let them nav up and down and change what they please.
>But, if thye're adding a new rec then they need to stay focused on the current rec and not be allowed to stray.
>How do you stop grid nav in such a situation? The only way I can see, at first thought, is using code in the BeforeRowColChange event.
>
>However, there are those of you out there who have doubtless tackled this problem, so I was seeking some input/guidance/tips and/or pointers.
>
>'ppreciate it
>
>Terry

This grid could be based on cursor so users can navigate during 'add' mode and all validatons will be done on save point.