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