General information
Category:
Forms & Form designer
Hi Sergey
I like the way you think. That would exactly cause this bug. However, the data is saved as "2004" not "1904".
After working on it this weekend, have Got it to work . . . kind of.
I put the following code in the rebuild() event of the ListNav1 List Box:
*=========
LOCAL nCount
m.ncount = 0
DODEFAULT()
SELECT donorhist
SET ORDER TO Wizard_1 && cID+ str(20991231 - val(cDate))
* this puts the ID in ascending & cDate in descending sequence
SET FILTER TO donor.cid = donorhist.cid AND (not DELETED())
GO TOP
COUNT TO m.nCount
GO TOP
this.Refresh()
*=========
This works fine except for the first record that appears when you open the form. It's in ascending sequence. As soon as you navigate to another parent record, then all child records appear in descending sequence.
Any ideas on hold to get it to work for the first record?
Bill Wright
P.S. I'm not that happy with this solution in that it's a "work-around", but after a while you get desperate. <bg>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only