By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Question On Combo Box

P: 1
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
Sep 6 '07 #1
Share this Question
Share on Google+
4 Replies


hariharanmca
100+
P: 1,977
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.
Sep 6 '07 #2

P: 10
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 *

Sep 6 '07 #3

hariharanmca
100+
P: 1,977
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
Sep 6 '07 #4

Expert 5K+
P: 8,434
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.
Sep 6 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.