I have a form with a subform. This is done to create a one to many relationship. The main form is Vendor and the subform is Vendor Account Number. 

On another form I enter the subform Vendor Account Number and want the Vendor Name field on that form to be filtered for the Vendor Name from the Vendor form based on the Vendor Account Number selected. 

The only way I've determined this can be accomplished is to include the Vendor Name in an additional field within the Vendor subform alongside the Vendor Account Number. 

If there is an alternate or more direct way, please share.

If this is the only way I need to know if there is a way to auto populate the subform Vendor Name field with the parent form Vendor Name.

Thanks!