Two Tables, One Form

Hi all. Here I go again ...the form I have (frmSupRFA) pulls data from two different places - a table (Supplier_Table) and the table (Suppliers) the form is bound to. The Suppliers table is update by the user by clicking on a command button that initiates an append query that appends data from the main table to the Suppliers table. After the user performs the append, then he choses a log number from a combo box to work on. That all works fine.

The issue I am having is the data that is pulled from the Supplier_Table - I cannot get it to save to the Suppliers table that the form is bound too. It is selected from the table by using an unbound combo box (SupplierName) that has six columns (SupplierID, ContactName, Address, City, State_Province, Postal Code). Its row source is a query called qrySupContact. These six columns populate six unbound textboxes (which works fine) using the following code:

Private Sub SupplierName_AfterUpdate()

Me.SupplierID = Me.SupplierName.Column(1)
Me.ContactName = Me.SupplierName.Column(2)
Me.Address = Me.SupplierName.Column(3)
Me.City = Me.SupplierName.Column(4)
Me.State__Province = Me.SupplierName.Column(5)
Me.PostalCode = Me.SupplierName.Column(6)

End Sub

How do I get the results to save to the Suppliers table with the rest of the record please? I know this is easy, but I cannot think of how to do it.

Thanks in advance for your help.

Camille