Thanks for your input.
I am opening a To Do file where the .Initaialize procedure is selecting a subset of the database, then opening the list view. If somebody edits a record that affects the selection criteria, for example marking an item done, changing a date, etc., that record became a blank line in the list. The Update button on my form is a temporary way for me to update the list while I’m trying to figure this out. There’s no way I would expect a user in a real world environment to press an update button each time they make a change to a record. That would not be acceptable. Even if they made a bunch of changes before hitting “update” the list would look like swiss cheese and be very confusing.
My update button (procedure) merely switches to graphics mode, then back to data mode (with no show, endnoshow) which usually refreshes the list. I added a line of code on every text editor object to reselect the subset of the database based on changes made and refresh the list but it still shows blank records for the unselected records.
That being said, we are making some progress here. Putting "info(“visible”) and ((exportline() contains «_liveSearch») or («_liveSearch» = “”))” in the list query field worked! It now shows only the records selected in the database, however, editing is still an issue. I have two popupbuttons that I am able to make update the form. I set them with Data being the field and comma separated values. I put the following code in the procedure pane:
Select Date≤today() and Type≠"Appt" and done≠"Y"
I think up record, down record is cleaner than switchtographicsmode, switchtodatamode, however there might be a problem if only one record is selected. The list will not update without the Select line but it does refresh with it.
I still can’t get a text editor object to update the list. I put the same code in the procedure section but it is ignored. I also tried the “switch” code but that still fails. If I manually switch from graphics to data modes, the list is updated. Doesn’t make much sense to me. I would appreciate any further ideas on that issue.
Finally, I note that building your text list this way is good for small databases, but I have found it slows down and other approaches are much faster when the size of the data grows.
What other approaches are you suggesting?