Combo Box Problems Dmunday 26.09.2006 14:50:01 Hi All, Afraid I am relatively inexperienced with Access, so please excuse the question if it seems silly. I have created a from/subform based on 2 tables. The tables are 'customers' and 'payments'. The main form has a combo box from which you select the customer code from table customers. This displays unpaid invoices for that customer from table payments. When I input the paid date on the subform, it correctly updates table payments but overwrites other customer codes in table customers. Is there any way of stopping this. Thanks in advance Derek