Question On Combo Box

[MRSS]

Dear Sir,

I am using two combo box in a form where ,if in 1st combo i chose an item exp. 220 then it will display in 2nd combo like cp1,cp2,cp3 etc.


Regards,
MRSS

[hariharanmca]

Dear Sir,

I am using two combo box in a form where ,if in 1st combo i chose an item exp. 220 then it will display in 2nd combo like cp1,cp2,cp3 etc.


Regards,
MRSS

Just post what you had tryed and mention your Front-end version.

[syamas]

Dear Sir,

I am using two combo box in a form where ,if in 1st combo i chose an item exp. 220 then it will display in 2nd combo like cp1,cp2,cp3 etc.


Regards,
MRSS

hello friend

let the combo boxes be cmb_box1 and cmb_box2
tables like tbl_country has field 'country' and tbl_state
has fields 'country' and 'state'

first loard countrires list on cmb_box1 as you know then
on_click() event of cmb_box1 write the code as follows
"select state from tbl_state where country = ' " & cmb_box2.text & " ' "
for loarding records as states to cmb_box2

plz do as the above theory

* link removed *

[hariharanmca]

hello friend

first loard countrires list on cmb_box1 as you know then
on_click() event of cmb_box1 write the code as follows
"select state from tbl_state where country = ' " & cmb_box2.text & " ' "
for loarding records as states to cmb_box2
plz do as the above theory

* Link removed *

Check your query that shound be cmb_box1.Text

"select state from tbl_state where country = ' " & cmb_box1.Text & " ' "for loarding records as states to cmb_box2

[Killer42]

I am using two combo box ...

Frankly, I'm amazed at the detailed responses you're getting, given that you haven't told us yet what the problem is.