>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