Auto populate subfrom from main form

[Tony]

I have a main form that contains data that I need to be automatically populated into a subform. The formula I've tried is:



Private Sub JobNum_Enter()

Me.OrderRelNum = Form.OrderJobLink_Frm.SalesOrderNum.Column(2)

End Sub




Me.OrderRelNum is located on the subform

SalesOrderNum.Column(2) is in the main form

I need the SalesOrderNum to be put into the OrderRelNum so I don't have to manually type it.

Any help is greatly appreciated!

Thanks,
Tony

 

[John W. Vinson]

I need the SalesOrderNum to be put into the OrderRelNum so I don't have to manually type it.

Simply include OrderRelNum in the Master/Child Link Field. This can consist of
multiple fields separated by semicolons.

John W. Vinson [MVP]

 

[Tony]

Thanks John - that did it.

--
Tony

Simply include OrderRelNum in the Master/Child Link Field. This can
consist of
multiple fields separated by semicolons.

John W. Vinson [MVP]