I have a form with 2 tabs on it. Each tab has it's own form. Form on tab 2 is a datasheet with a select button on each line. Clicking this button populates the form on Tab 1. The problem I am having is that I cannot select multiple lines on Tab 2 at the same time. I can select one switch to tab 1 and it's there and then go back and select another. If I dont switch tabs I just overwrite the record there. I am using acNewRec but this obviously doesn't get activated until I switch tabs. I have tried requery but this doesn't work.