I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I ensure that the invoice data goes to the correct record on the subform datasheet? It seems to depend on where the cursor was before leaving the subform. I want to be sure that the invoice data goes into the most recent record [they are listed in date order]. Is there any way in VB to ensure that the invoice data goes to the correct record? Thanks

Software/Hardware used:
microsoft access