I did pretty much the same thing.

Try this:

select description from look into cursor mycursor where look.type = THIS.pcType

Also if nothing else needs to use the curso this creates you can store an array in a property of the combo.

Create a new property call aList[1]
Change the RowSource to this.aList
Change the RowSourceType to 5-Array
Put your select in the requery method of the combo

 select description ;
         from look ;
         where look.type = THIS.pcType ;
          into array this.aList

add this.requery to the init event.

That way it's all nice and neat.

hth
>I've set up a 'LOOKUP Combo' which uses a SQL select clause to select records from a lookup table. The lookup table has different records in it , with one field which specifies a Type, e.g. Type = 'GROUP' is in all records which are classified a s a group, Type = 'REP' for all records which are classified as a Rep.
>
>I want this Lookup to be global, with a parameter which specifies the type of lookup. I'v set this parameter up as a Property in the class (property is pctYPE) and my SQL select is as follows:
>
> select description from look into cursor mycursor where look.type = pcType
>
>
>I've saved this as a Class and thought that I could use this for any Lookup by just setting the property accordingly...... but message comes up saying property can only be used in method code !!
>
>Anybody know any workarounds ?
>
>Regards,
>
>Gerard