>Hello everyone,
>
>I have a form with two grids. The main table is BldMstr, the other is Lender. BldMstr is ordered by lName. I scroll through the grid and if I find lender code, which could be changed, I dblclick on the Lender grid and this action puts new Lender code into Lender field and assign NULL to lname. It also calls tisform.Next() method, which moves to the next record. Now you can easily see my problem: I assign NULL, so the record pointer jumps to the top, which is inconvenient for the user. What would be the best and simplest way to move to the next record, which was next before assigning NULL.
>
>Thanks in advance.
Been a while since I worked with grids...but whereever you are doing the insert, I would think you'd have to capture the record number of the record the user is on before the insert is performed. That way you could return and SKIP to the next one.
One way to do this might be thru the grid.BeforeRowColChange method (put code there to save the RECNO() to a form property).
Hope that helps...
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
