I am in need of a little help please,,
When you add a new record using the below, txtID will be set to 0 on the main form, and when you hit the save button the record set will save to the next free record, however, on the table "Commentary", the CustomerID keeps saving as 0, "for a new record"...