Filtering from combo box

[rclarke]

Hello

Hope everybody is well?

I have a combo box with the following code in the interactive change event

thisform.dataenvironment.cursor2.filter= ;
"alltrim(wbg_swb)='"+alltrim(this.value)+"'"

this limits the number of VA tickets that come up in the second combo boxe

This works fine How ever when I add another load to store the list of weighbridge numbers only shows the one item selected for the filter.

My question is how do I get it to clear the filter I tried SET FILTER TO in the save button and in the lost focus even of Combo 2.

All help is much appreciated

Rachel

 

[ramani]

Hi
When you select another load to store the list of weighbridge numbers .... Just before processing it.. set back
thisform.dataenvironment.cursor2.filter = "" or to the value what it was when you initialy started the form.

The key is 'set filter to' whatever you want.

Hope this helps.. Right now I am in haste... Best of luck
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[ramani]

Hi
Regarding your "My question is how do I get it to clear the filter I tried SET FILTER TO in the save button and in the
lost focus even of Combo 2."

Simply put the code
SELECT myAlias
SET FILTER TO

Hope this helps
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[rclarke]

Ramani

Much appreciated will try that thank you