Two Connecting combo boxes via VBA

[noble]

Hi

I have two combo boxes in a single form, they are connected to different tables, I wand one of them change it's fields when I choose any special field in the other combo, as a matter of fact I want them to be dynamic.

for example if I choose field #1 in combo #1 (from table #1), fields #1 and #2 from table #2 should appear in combo #2
and if I choose field #3 in combo #1(from table #1), fields #5 and #6 from table #2 should appear in combo #2

anybody please help me?

 

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/CascadingCombo.htm

 

[Alansidman]

I believe you are referring to the concept of cascading combo boxes. Look at this link.

http://www.access-programmers.co.uk/forums/showthread.php?t=223980

 

[noble]

Is this what you're looking for?



hey!
I followed the instructions! but it didn't work
is there any special tip or smth else I should do before using the VBA codes?

my tables are:
tblStudent : sID(key),sName,sAvg
tblCourse: cID(key),cName,type,unit
tblchoose: ID(key),sID(forein key),cID(foreign key)

in the form I have two combos and a text box
cboStuddent and cboCourse and txtstID

I want the txtstID to show the student's ID when the user selects the student's name from cboStudent and the cboCourse to show the courses that student have chosen ( which indicates in the tblChoose table)

as a matter of fact! I wanna the cboCourse filtered by the cboStudent's values

what prior settings I need to do so?

thanks

 

[pbaldy]

The textbox is a different animal:

http://www.baldyweb.com/Autofill.htm

As to why the cascading combos didn't work, I have no idea what "didn't work" means. Error, wrong result, etc.

 

[noble]

hum! this is what I meant by "didnt work"!
I leave my database and follow this page instructions :
h*ttp://msdn.microsoft.com/en-us/library/office/bb404901(v=office.12).aspx

but the cboProducts didnt show the filtered values! and the two comboes didnt connect at all!
is there any other tip I should know about tha tables or relationships?

Oh! btw that textfield is not my problem anyway, I dont care it n I could omit it!

 

[noble]

hey!
I followed the instructions! but it didn't work
is there any special tip or smth else I should do before using the VBA codes?

my tables are:
tblStudent : sID(key),sName,sAvg
tblCourse: cID(key),cName,type,unit
tblchoose: ID(key),sID(forein key),cID(foreign key)

in the form I have two combos and a text box
cboStuddent and cboCourse and txtstID

I want the txtstID to show the student's ID when the user selects the student's name from cboStudent and the cboCourse to show the courses that student have chosen ( which indicates in the tblChoose table)

as a matter of fact! I wanna the cboCourse filtered by the cboStudent's values

what prior settings I need to do so?

I have two combo boxes in a single form, they are connected to different tables, I wand one of them change it's fields when I choose any special field in the other combo, as a matter of fact I want them to be dynamic.

for example if I choose field #1 in combo #1 (from table #1), fields #1 and #2 from table #2 should appear in combo #2
and if I choose field #3 in combo #1(from table #1), fields #5 and #6 from table #2 should appear in combo #2

anybody please help me?

 

[pbaldy]

Can you post the db here with the failed effort?

 

[noble]

yes!
here's the attached DB
please take a look at relations and VBA code for cboCategories

 

[noble]

p.s: the second combo is empty! (cboProducts)

 

[pbaldy]

Hard to test when the tables are empty, but you don't have CatID included in the first combo, so it's not available for the second.

 

[noble]

would u plz make changes needed in the form and tables and attach the db back to me?

I don know how to include the catID to the 1st combo
I am a very begginer
will be full of thanks