I have a form with two combo boxes (Wholesaler and Store). In the same form I have a table in datasheet view as a sub-form which shows all Wholesalers and all Stores. I want to be able to select a Wholesaler and a Store and I want the table to show only the entries matching that criteria. Any suggestions?
Last edited by wilburc; 07-20-12 at 18:24.
Reason: pasted wrong text
Table name should be the Origional table. you have .form to show the information passsing through a subform. now wholesaler and store, those are the names of the combo boxes where you select the the values. At the end of the combo boxes you can set up code for after update.
Docmd.me.Requery, this will essentailly refresh the table, therefore searching the data