Tabbed form help

[jbphoenix]

I have several forms that I have put together on 1 form using tabs. They are linked using an OrderID. One of the subforms is linked using the OrderID as well as the CustomerID. The reason I did that was because the users need to see the customer data (Name, addr, contact numbers). The CustomerID and OrderID are automatically entered into the subform.

So when the user enters the CustomerID on the main form it also appears on the tabbed subform. That works fine.

If the form is on it's own the rest of the customer data populates when the CustomerID is entered. But on the tabbed subform version only the CustomerID and OrderID populate. How do I get the rest of the customer data to populate?

Here is the code I have

Private Sub Customer__AfterUpdate()
[CustNum] = [Customer#]
[CustomerName] = [CustNum].Column(1)
[Addr1] = [CustNum].Column(2)
[Addr2] = [CustNum].Column(3)
[Addr3] = [CustNum].Column(4)
[City] = [CustNum].Column(5)
[State] = [CustNum].Column(6)
[ZipCode] = [CustNum].Column(7)
[ContactPhone] = [CustNum].Column(8)
[ContactFax] = [CustNum].Column(9)


End Sub

 

[neileg]

Why not bind the subform to the query instead of using code. The bound controls will automatically populate. You don't need all that data hanging on the combo box.