I'am a new user of access and thinking if it is possible to have an option for a multi search in a form in access. the scenario is this, I'am handling 20K+ records of our employees on my table and everytime i update my record i used v-look up and filter in excel manually. I'am using their passport no as the look up value to filter the records that i needed. because usually the emails comes in a bulk of records that i need to update. If there is like a copy and paste option in the access then will multi search will start.
Please provide the codes that i needed. Thank you so much in advance