Hi,
I have a form (the parent form) which has a subform that is in datasheet view populated with records according to whatever is selected in an unbound combo box that has been placed on the parent form.
The subform can potentially list thousands of records as a result of the user's selection, which is as desired.
The records shown in the subform need to be listed in ascending order (i.e. the oldest record is at the top, the most recent at the bottom in the subform).
To duplicate the last-added record the user can either click the tiny hard-to-see 'New (blank) record' button at bottom-left of the subform causing the subform to jump to the bottom of the list of records and adds a new blank record ready for data entry, then the user selects and copies the last-added record and pastes it on top of the new blank record, or, the user scrolls all the way down through the thousands of records listed in the subform to get to the last-added record, and select copy and paste as above. Either way is messy.
I would like to the user to be able to duplicate of the last-added record in the subform using a Duplicate Record command button placed on the parent form. Thus not placed on the subform, as apparently the only way to do so is to have the subform display its records in Continuous mode and place the Duplicate Record button either in the subform's header or footer - but that is not desired.
Therefore, if possible, I'd like, on opening the parent form containing the subform which is in Datasheet mode, and upon the user populating that subform with records the subform then automatically jumps down to and displays the last few recently-added records, and adds a new blank record ready for data entry, so that if the user desires, clicks a Duplicate Record that is on the parent form, and the most recently-added record shown in the subform is duplicated into that new blank record (and another new blank recorded added ready for the user to do either again.
Is this possible? Any help regarding the vba code (vba code much preferred) that needs to be in the Duplicate Record button placed on the parent form would be very much appreciated. Cheers, Allen.