DTC Listbox

[david7777777777]

I have made an editable grid DTC as Merlin instructed. How do I get a listbox to display the current value in a field of a record instead of showing the last selected value in that list box when I go from one record to another?

 

[Metka]

If the properties of your databound listbox are properly set (Recordset field on General tab and Row Source,.. on LookUp tab have to be bound to 2 appropriate recordsets) and incorrect value is displayed in the listbox it probably means, that you open your recordsets after the creation of the Listbox. In this case you can set Listbox properties manually (for example in the thispage_onenter() event). The syntax is as follows:

ListBox1.setDataSource(recordset1)
ListBox1.setDataField("column_name&quot
ListBox1.setRowSource recordset2, "column", "bound_column"

hope this helps.

 

[MerlinB]

Yes - try moving the list/combo box (and all other DTC's that appear inside the grid) AFTER the grid.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)