How to populate subform fields when drop down selected in main form

[aladinabox]

Hi,

I really hope someone can help me, I've been trying to get this working for weeks now. I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at the moment, that for example, when a certain course is selected, that their modules will appear in the subform. Where my problem arises is that I have a relationship between two tables that I want to appear on the subform, so that details can be filled in on the subform against the list of modules that automatically appear. I hope this makes sense? I can post database if anyone thinks they could help me, and I would really appreciate anyones' advice.

Thanks for your time.

 

[jdraw]

Please post your database -- compact it and zip it -AND remove anything confidential.

 

[aladinabox]

Hi jDraw,

Thanks so much for the quick reply. Please find database attached. You will see the General Contact Info form. That is the one I am working on. The course ID in the main form is linked to populate the Common Awards subform with the Modules attached to each of the courses. I'm looking to also use fields from the ContractAssess table to fill in some of the date fields that will go against each of the modules that populate into the subform. I thought I had all the relationships in correctly, but any advice will be very much appreciated. And just let me know if I need to clarify anything.

Thanks again.