D
Dmunday
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
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