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

One idea, yes, thanks.