Maybe this can't be done but I am trying to write a record to a table using a temporary table made from a make table query. But I also want to write a couple of the fields from a forms fields.
I have this code in the after update event of a combobox on the form:
Dim RS As DAO.Recordset
Set RS = CurrentDb.OpenRecordset("tblUnitLineItems")
!JobID = Me.txtJobID
!UnitID = Me.txtUnitID
!Category = Me.cboCategory
!LineItem = Me.cboLineItemDescription
!Quantity = Me.txtQuantity
!Price = Me.txtPrice
!MasterItem = Me.chkbxMasterItem
!LineItemID = Me.txtLineItemID
Set RS = Nothing
But I want the record source for the following fields to come from the temporary table:
But then I want the following fields to come from the form fields:
Can this be done? How would I re-write the code if so?