Auto populate subfrom from main form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 03 Aug 2007 00:43 GMT

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

Reply to this Message

John W. Vinson - 03 Aug 2007 01:53 GMT

>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]

Reply to this Message

Tony - 03 Aug 2007 18:50 GMT

Thanks John - that did it.

Signature

Tony

>>I need the SalesOrderNum to be put into the OrderRelNum so I don't have to
>>manually type it.
[quoted text clipped - 4 lines]
>
> John W. Vinson [MVP]

Reply to this Message