>>>>>No. Besides, I'm not using the menu but testing the form stand-alone. Stand by - I'm homing in on it. The problem is in the form's .Init() but the offending line is giving me a invalid func, arg, value err at the moment.
>>>>
>>>>
>>>>I still want to know the filter code :-)
>>>
>>>You got it now?
>>
>>lcFilter = "OPERATOR = " + ALLTRIM( STR( lnOperator)) + " and " + ;
>> "DTOS(END_DATE) >= '" + DTOS(ldDate) + "' or EMPTY( END_DATE)"
>>Select RTEFAM
>>Set Filter To &lcFilter
>>
>>?
>
>
>BB
>
>This wouldn't seem to be the problem now - it's why this code is fired when dropping the route combo. That should only fire when dropping and changing the operator combo.
>
>Cheers
>
>Terry
Terry,
I don't know the code of that form, maybe when that combo got the focs some other control that have RowSource based on RTEFAM table needs to be refreshed and try to refresh the filer of that table?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.