?
Solved

Problem with Foxpro 6 list box refreshing

Posted on 2011-02-26
2
Medium Priority
?
974 Views
Last Modified: 2012-06-21
I have a fairly complex application (to do with plants) that has two list boxes to select records in a table.  One uses a field called 'species' and the other a field called 'com_name'.  As well as this the order can be set to five different values (species, com_name, form, family,flr_col).  All goes well till I change the index to something other than the default 'species'.  After moving around in the table the list box looses some of the records, showing blank spaces.  If you click in a blank space the name appears.
The list box is on a separate page of the pageframe but the result is the same if on the same page.  I use the code
thisform.pageframe1.page11.lstSelcomn2.listitemid = listid
thisform.pageframe1.page11.lstSelcomn2.setfocus
thisform.pageframe1.page11.lstSelcomn2.refresh

to refresh the list but this still does not work.
If the index is set to say 'family' it is set back to 'species' when the page containing the list box is selected, then back to 'family' after the selection is made.

Is there any other code that will keep the list box refreshed?
The first image shows when it goes bad and the second one is when I click on a blank area.  Some of the items come back but not all. List box with blanks List box after clicking - some names seill missing
0
Comment
Question by:Conroy111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 2000 total points
ID: 34990969
You may try to call

thisform.pageframe1.page11.lstSelcomn2.requery  after index change.

It should reread the listbox items from the row source.
0
 

Author Closing Comment

by:Conroy111
ID: 34993174
Thanks pcelba, fixed it completely.
0

Featured Post

Automating Terraform w Jenkins & AWS CodeCommit

How to configure Jenkins and CodeCommit to allow users to easily create and destroy infrastructure using Terraform code.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question