how to make my drop down box to select a group and display it

[kitaeshi]

hi all i have attach a db3.mdb(4.6mb) that i have been working on. On the top of the "volunteerform", there is drop down box name "jgroup.group" which show all the following groups. What i want to do is if i select which group, the form will automatic show the members belong to that group on the form. But i try for the whole weeks still cannot make it work. -_-

About the form.
the "volunteerform" is generate by a query call "selectGroup" query.
to open the volunteerform, go to the form and open "selectGroup" form, then choose which group u want.

tks for viewing.

 

[MStef]

Look at "DemoSelectGroupA2002.mdb" (attachment).
Look at Table1, Form1, VBA, query SelectGroup.
Open Form1 and try.
Adapt it in your mdb.

 

[kitaeshi]

hi, but my one got foreign table. "jgroup" to link "members" & "vgroup" together.