SUBFORM - dropdown issues

[travismp]

Little help please… I have done this before but must be missing something small… you will need to download the db attached…too much to describe.

Please open the db. There will be a start form. Click on the first button tittled:

‘Client Form’

This will launch a main form with two subforms. All coming from the same query. I want one main drop-down with the ‘client name’ and when that name is selected then the fields within the subform to be populated with the corresponding information.

Right now if you open the form there is already information & when you select a clie t name from the drop-down the subfield does not even change.

What am I missing all???

Thanks

 

[adevera]

Your reference to Child and Master Fields of the subform is invalid.

On your subform, frm_Client_sub, you must set the Link Child Field to Company_Name (which is the name of the textbox for the co name) and Link Master Field to clients (this is the name of your combo box in the main form).

 

[travismp]

Thank You

That worked perfectly & makes sense now as well. Thank you again & again.