DropList Filter not working properly. Suggestions ?

[britech]

Hi Folks,

I have a field on a form, where I have a DropList that needs to be filtered.

'CHA:ClientID=5'      THIS WORKS! in the filter.

'CHA:ClientID=LOC:Client_ID'     DOES NOT work.

I know that LOC:CLIENT_ID=5  , because I have messaged it at these 3 embed Points:

GenerateForm / Start

Generate Form / Before Form

InitForm / Start

LOC:Client_ID = 5  at all three locations in the code.
I have added LOC:Client_ID as a hot field, I have added CHA:ClientID as a hot field.
Nothing seems to work.

Suggestions?

Brian

[kevin plummer]

try

'CHA:ClientID=' & LOC:Client_ID

[britech]

Perfect !!!!!
Forgot this was being thrown into a PROP:SQL statement, which knows nothing about LOC:CLIENT_ID.
Good eye Kevin, and thanks.

Brian

[Robert Iliuta]

Thank you tooo Kevin!
Didn't know why was not working....
Robert