ComboBox Set Value?

[Former Member]

Hi all!

==============

Source coding

==============

oRecordSet.DoQuery "Select Code, TreeType, PriceList, Qauntity, ToWH From OITT Where Code = '" & oCode & " '"

a = oRecordSet.Fields(0).Value '//Code

b = oRecordSet.Fields(1).Value '//TreeType

c = oRecordSet.Fields(2).Value '//PriceList

d = oRecordSet.Fields(3).Value '//Qauntity

e = oRecordSet.Fields(4).Value '//ToWH

Set oEditText1 = oForm.Items("4").Specific '//Code

Set oEditText2 = oForm.Items("7").Specific '//Qauntity

Set oCombobox1 = oForm.Items("9").Specific '//ToWH

Set oCombobox2 = oForm.Items("13").Specific '//TreeType

Set oCombobox3 = oForm.Items("15").Specific '//PriceList

oEditText1.Value = a '//Code

oEditText2.Value = d '//Qauntity

oCombobox1 = ?

oCombobox2 = ?

oCombobox3 = ?

-

---

already there is setted each comboboxs.

After the query is maded each cell(item) should be setted.

How can I set a value of each combobox cell ?

Thank you for your help.

[Former Member · Accepted solution]

The select method of a combobox lets you set the current value for it.

oCombobox1.Select x, psk_ByValue

The second parameter has the following options
psk_ByValue        Locates by item value.
psk_ByDescription  Locates by item description.
psk_Index          Locates by item index.

John