I am developing a UI in Access 2007 using ODBC. The form1 has a logic in order as bellow
1. With search box filled with a list of IDs, on click on the search button (Before.png in attachment)
2. The VBA code will run a query to get corresponding customer_id, customer_name in customer(linked...