Records filtering

[Naqibullah]

Hello my dear sincere and lovely friends hope each one of you are doing well!!!
i just had a little bit difficulty...let me explain my scenario i have a list of groups these groups each have their list of members each member takes loan and repay the loan in a no. of installments my problem is in a new form i want to look up for a specific group within list of groups and when that group is chosen only its members should be displayed in another combo box and when i select a specific member from this member list combo box the member's primary key should appear in the child tables such as loan, repayment and savings, as i will create a no. of tabs for these child tables. so that when i do data entry of loans or repayments i look for the group first rather looking for each member in list 10000 members...
thanking you in advance

 

[jdraw]

Here are 2 free video tutorials on Cascading Combo boxes.
These should help with concepts and techniques.
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Good luck.

 

[Naqibullah]

Thanks for the nice reply i have created two combo box of countries and their cities, but when i select a specific country its respective cities doesn't appear in city combo box, so i attached an example of my db in this reply plz explain my error in this db

 

[JHB]

You are referring to a wrong control in your query for "Combo4".
And then you need a to requery "Combo4" after "Combo2" has been updated.

 

[Naqibullah]

i really appreciate ur endevour....
thanks again for your nice and ontime reply