>>Listbox is not editable :) So you could make its rowsourcetype = 3 (SQL) and write SQL statement to RowSource.
>>
>>Cetin, Can I put multiple SQL lines of code in the rowsource?
>>Start with something like:
>> "select name, date, detail, noun,quant from ledger"
>
>

---

Yes Tim,
>You could use long SQLs but not directly in PEM sheet. Leave Rowsource, Rowsourcetype at their default. Use init of Listbox. As a sample :
>

local lcSQL
>lcSQL = [select customer.cust_id, Company, ]+;
>	[   orders.order_id, order_date, order_net, shipped_on, ]+;
>	[   line_no, prod_name ] +;
>	[ from customer ]+;
>	[      left outer join orders ]+ ;
>	[        on customer.cust_id = orders.cust_id ] +;
>	[      inner join orditems ]+ ;
>	[        on orditems.order_id = orders.order_id ] +;
>	[      inner join products ]+ ;
>	[        on orditems.product_id = products.product_id ]+;
>	[ into cursor myCursor]
>with this
> .RowSourcetype = 3
> .Rowsource = lcSQL
> .ColumnCount = 8
> .ColumnWidths = "50,60,70,50,60,70,50"
> .Boundcolumn = 6
>endwith

Cetin

I understand where you're going with the sql but the trick for me is to have the listbox set to the bottom of the file as if the user had 'arrowed' all the way down tothe bottom.