I have quite a complex database. It has many subforms on the main form. The main form can have multiple records for each client and opens on the last record. The subforms have multiple records for each client and I need them to open on the last record, I also want a button on the subform that copies the last record and creates a new record that can then be edited. I have tried the duplicate record on a button and it doesn't seem to work. If any one can help me I would be very grateful.
Dec
Dec