You are not logged in.

fomaxrge

Trainee

  • "fomaxrge" started this thread

Posts: 88

Date of registration: Aug 14th 2012

  • Send private message

1

Tuesday, October 16th 2012, 3:52pm

msgbox with the value of selected item of a combobox

Hi again!
I need your help please!

I have a combobox that fills with the results of a mysql query.
Is there a way to have a msgbox that appears the value of the selected item?

I mean that...
whenever i make a selection from combobox to appear a msgbox that tells ...
"your selection is..."

To help you,
as i told you i have a combobox with categories (that fills from a mysql selection) and now i am trying to take the selected value of this combobox to make another mysql selection that fills my other combobox that calls subcategories.

for example if the selected value = "x"
to make this

'sub catigories combobox
Set Data = Order.executeQuery("SELECT * FROM katigories_esod_exod WHERE subcatigories = "x" GROUP BY subkatigories ORDER BY subkatigories")
Do While Data.next()
subkatigories = Data.getString("subkatigories")
ComboBox_katigoria.AddItem New ListCellData(subkatigories, all_subkatigories, False)
Loop


thanks in advance

This post has been edited 1 times, last edit by "fomaxrge" (Oct 16th 2012, 4:25pm)

theuserbl

Intermediate

Posts: 436

Date of registration: Dec 20th 2008

  • Send private message

2

Thursday, October 18th 2012, 12:35am

RE: msgbox with the value of selected item of a combobox

Quoted from "fomaxrge"

Hi again!
I need your help please!

I have a combobox that fills with the results of a mysql query.
Is there a way to have a msgbox that appears the value of the selected item?

I mean that...
whenever i make a selection from combobox to appear a msgbox that tells ...
"your selection is..."


Currently I don't know where the bug is in ListData.
But currently it will help to use Parent.getItemAt instead:

Jabaco Source

 
1
2
3
4
5
6
7
8
9
10
11
12
13

Public Sub Form_Load()
   ComboBox1.AddItem("first entry")
   ComboBox1.AddItem("second entry")
   ComboBox1.AddItem("third entry")
   ComboBox1.AddItem("fourth entry")
   ComboBox1.AddItem("fifth entry")
   ComboBox1.AddItem("sixth entry")
   ComboBox1.AddItem("seventh entry")
End Sub

Public Sub ComboBox1_Change()
   MsgBox("your selection is " + ComboBox1.Parent.getItemAt(ComboBox1.ListIndex))
End Sub


Greatings
theuserbl

fomaxrge

Trainee

  • "fomaxrge" started this thread

Posts: 88

Date of registration: Aug 14th 2012

  • Send private message

3

Thursday, October 18th 2012, 12:51pm

combobox_change() was exactly what i was looking for.

Thank you very much for your help and for your precious time you spend on my problem too.
Have a nice day!

Similar threads

Rate this thread
WoltLab Burning Board