Its on a remote data base. The full create view was:

create sql view qsys_lookups remote connection myconn as select * from sys_lookups where set_name = ?this.lookup_set_name

I need to requery() the data a bunch of times, since I am using about 10 dropdowns, each populated with a different set of records from that table.

A remote view and a custom property seemed like the way to go.

>>Todd,
>>
>>Do you need this view for other purposes or only
>>for the source of your drop-down comboxbox?
>>
>>If the latter, I suggest you do it this way:
>>
>>Set your drop-down combo RowSourceType to SQL Statement (3)
>>and the put your SQL Statement as the RowSource. This would be
>>something like this:
>>
>>RowSource=select * from lookup_table where set_name=thisform.MyValue
>>
>>You need to define a new property for the form called MyValue where
>>your store the information for your query parameter.
>>
>>HTH
>>
>>Pascal
>
>Also, be sure that the property is of the correct data type and not thee default of .F. which might cause an error if the query is expecting char/numeri.