I have 2 combo boxes, one for shipper, one for consignee (both bound to tblShipCons). I also have an option group for user to select which one (shipper or consignee) should be the bill to number. I don't know how to get the bill to number populated in the table(tblInvoice). It was suggested to me to use an SQL statement to update the table but the record does not exist yet. If I try to cursor into the subform (combo box and option group are not in subform) to allow the write of the record, I get the error 'You cannot add or change a record because a related record is required in table 'tblCustomers', which leads me to believe that the record cannot be written without some value in BillToNumber.