Auto populate subfrom from main form

  • Thread starter Thread starter Tony
  • Start date Start date
T

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
 
I need the SalesOrderNum to be put into the OrderRelNum so I don't have to manually type it.
Click to expand...

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

John W. Vinson [MVP]
 
Thanks John - that did it.

--
Tony

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

John W. Vinson [MVP]
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update subform with combobox change on main form 1
Main Form and two Subforms 2
Auto populate 5
Filter SubFrom from Main Form using date 1
set focus to subform in subform from main form button 1
Populate sub form 1
Access Main form/Subform Navigation 0
Passing Data from a Main form to a Sub Form 1

Back
Top