>Excellent!
>Can you take a look on the following?
>

ccount=getfiltercount("mytable", "between(id,521548,529785)")
>thisform.txt1.value=ccount
>
>function getfiltercount(tctable, tcfiltercondition)
>	local lnselect, lncount
>	lnselect = select() && Save current work alias!
>	select 0
>	use (tctable) again
>	count for &tcfiltercondition
>	lncount = _tally
>	use
>	select(lnselect)
>	return (transform(lncount))
>endfunc
>

>

Update: Realized there might be problems if (tcTable) is actually a cursor or in an open database that wouldn't be active when you change the datasession

Here's another approach

FUNCTION getfiltercount(tctable, tcfiltercondition)
    LOCAL oData
    LOCAL ARRAY aResult[1]
    oData = CREATEOBJECT("session")
    SET DATASESSION TO oData.datasessionid
    SELECT COUNT(*) FROM (tcTable) WHERE &tcFilterCondition INTO ARRAY aResult
    oData = .NULL.
    RETURN TRANSFORM(aResult)