It's called "grid reconstruction". What you've done is destroy all the code that went with the grid. You may be able to stop that behavior by blanking the grid.RecordSource property, getting the new data via SQL, and then resetting the grid.RecordSource property to your new alias for the SQL cursor. Even if they're the same name, you still have to do this. You may also need to reset your Column.ControlSource property of all your columns if your fields in the grid or in any order other than what the fields in the cursor are.
Fred On Thu, Aug 8, 2013 at 1:44 PM, Rafael Copquin <[email protected]>wrote: > Again with hot key blues!:-( > > I have this form with a grid and a series of hot key calls from the > keypress event of one of its columns (the textbox of the column) > > All goes well, until I change the underlying cursor of the grid. > The hot keys no longer work > > IOW, I use a select statement to show a cursor in the grid. The hot keys > work. > Then I use another select statement to populate the grid. And now the hot > keys do not work any more > > Why? > > Please help! > > Rafael Copquin > > ______________________________**_________________ > Post Messages to: [email protected] > Subscription Maintenance: > http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox> > OT-free version of this list: http://mail.leafe.com/mailman/** > listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech> > Searchable Archive: > http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox> > This message: http://leafe.com/archives/**byMID/profox/52040320.1040005@** > fibertel.com.ar<http://leafe.com/archives/byMID/profox/[email protected]> > ** 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. > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksqSfPh-r5q8+KodfFh7fF6rWw-iRauMfeWjEZiOE4=u...@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.
