Who can help me on my select problem?

[#1]

I think this might be a chalange for some people

Who can help? I try to explain what is happening.

I have a list box with amount of days, called rangedays.

I also have a table with many fields and one is a calculated agveval field, which is how old the record is.

When I click on a rangeday, i do a select on the table with ageval <= rangedays. (This is in a trigger, onChange and onSelect on rangedays)

'Field' = ageval, 'Search String' = ='<='&rangedays

The values of ageval in the table/records are from 7 to 999.

I also have a field, showing GetSelectedCount(ageval)

This all seem to work, so now the problem so far.

I now first do a sub-select of other values and lock them. (The lowest ageval value of these records is 40)

When I now click on rangedays 47, I see that GetSelectedCount(ageval) is 3 (which is fine and correct)

But when I click on any rangeday number between 7 and 39, it will not change the GetSelectedCount(ageval) value. As there are non, I would like to see that.

When I click on 6 or lower, the GetSelectedCount(ageval) now is changing to 0, which is the number in the whole table.

So what i think the GetSelectedCount is not working as I had hoped.

I like to know how many records are left from my subselect.

Is there maybe an other function for that? Or another solution to my challenge?

[#2 · Accepted solution]

I think I resolved my own problem, with help on another question I had.

I first needed to do a clear on the specific field.

To do that, I do a "select in Field" with a blank search string.