If you need to do things based on the value after you've moved the row and changed with the click, then the place would be in the Valid of the checkbox. All references would be to the table values there, which would be on the correct row.
Fred On Wed, Aug 22, 2012 at 5:03 AM, Michael Savage <[email protected]> wrote: > That is exactly what is happening.. If the before value... issue you > mention. Where should I put my validation code, so that when I click on > the check box column, it goes to the right row. > TIA, > Mike > On 22/08/2012 12:21 AM, Fred Taylor wrote: > > Its really got to be some other code somewhere. I just whipped up a > simple > > for with a grid with a checkbox. Works as expected. > > > > Put a WAIT WINDOW as the first line of code in the AfterRowColChange > event > > so you can see what the value of the field is. The value should be > what's > > in the cursor/table of the row you've clicked into. Be aware that if > > you're clicking in the column with the checkbox, the value will be what > the > > value was BEFORE you clicked on the row. Clicking in the column changed > > the value after the AfterRowColChange event fired. > > > > Fred > > > > > > On Tue, Aug 21, 2012 at 8:59 PM, Fred Taylor <[email protected]> wrote: > > > >> Do you have any code in any of the text boxes, headers, columns, grid > >> events/methods? That may be causing strangeness in the normal flow of > the > >> events. > >> > >> Wait a minute, you said toolbar. That can also impact the flow of > events. > >> > >> Fred > >> > >> > >> > >> On Tue, Aug 21, 2012 at 8:16 PM, Michael Savage <[email protected] > >wrote: > >> > >>> I thought that, but that does not seem to be happening... > >>> My first column is a logical with a check box in it. After I pick edit > >>> from my toolbar on my form, I then proceed to go to the grid. Let say I > >>> move the mouse to row 7. > >>> When I click on row 7, the After... fires, before row seven gets the > >>> focus. > >>> > >>> Any ideas of what I am doing wrong? > >>> > >>> TIA, > >>> Mike > >>> On 21/08/2012 7:44 PM, Fred Taylor wrote: > >>>> You should already be on the correct record from the RecordSource of > the > >>>> grid. You should be referencing the table/cursor field, not the > >>>> Column.Text1.Value. > >>>> > >>>> Fred > >>>> > >>>> > >>>> On Tue, Aug 21, 2012 at 4:39 PM, Michael Savage <[email protected]> > >>> wrote: > >>>>> I have some code in a grid's AfterRowColChange method to call a > method > >>>>> on the form for some on the spot validation. > >>>>> > >>>>> When I activate the grid for editing, it is normally at the top. > >>>>> I pick the row I want, and prior to moving, it runs the code in the > >>>>> AfterRowColChange. > >>>>> How do I get the validation to occur after I have focus in the new > row? > >>>>> > >>>>> I'm very confused. > >>>>> > >>>>> TIA, > >>>>> Mike > >>>>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksoZHnU0OEt5XhYWPf48mO6rTPYd6s=shjzbp5_vbna...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
