Subject Re: last record in indexed table out of wack From Charlie <tm@tc.com> Date Fri, 13 Dec 2024 16:44:20 -0500 Newsgroups dbase.getting-started Thanks so much! form.QueryName.rowset.refreshControls()    solved the problem!! Ken Mayer Wrote: > On 12/13/2024 10:22 AM, Charlie wrote: > > I have a stupid problem with an indexed table.  I can't give a lot of info on this but I am just wondering if anyone has run into this problem based on my description of what is happening. > > > > The table is indexed.  It opens and is supposed to open with the record it was on when last closed.   That part works fine except the very last record in the table which instead of showing it's own data, is showing data from the first record.  if you click on the record with the incorrect data it corrects itself with the correct data.  But before doing that, it is as if it is null and not part of the indexed table. > > > > Anyone ever experience something like this and if so how did you resolve it.  I have tried to reindex the table which doesn't help.  It may be a coding problem which will be complicated. > > Haven't seen that issue, but you may want to see about refreshing > controls on the form after navigating to that record: >     form.rowset.refreshControls() > > If you need a specific query (not the one assigned to "form.rowset"), then: >     form.QueryName.rowset.refreshControls() > > I can't guarantee that will solve it, but ... > > Ken > > -- > *Ken Mayer* > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm > dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm > dBASE DOS to Windows Tutorial: > http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm