Hello, I am trying to accomplish the following with Access 2010: 1. Filter records stored in a table by typing characters that are contained in a text field. The text filter on the shortcut menu searches and returns records to suit me but I need it to make several selections. Combo box does similarly, but returns only those records that begin with the characters you type. 2. Select the desired record from those displayed and add that record to a current list. 3. Repeat filtering and adding until all desired records have been added to the current list. 4. Displ the current list in a report or form for printing or saving as a text file. I will be grateful for any tips on the best way to do this. My most valued assistant has long been constrained to pouring through several 500+ page catalogs to select items for ordering from a few suppliers. My belief is that Access can save her a huge amount of time and surely someone else already has a solution. All the selection criteria she needs would be in the Item column
ID Cwip Item CatPage
252 32725 FIXT:DRUM:13"RND:WHITE:3-PL13 227
253 25252 FIXT:DRUM:13"RND:WH:1FC8&1FC12 227
254 22067 LIGHT PANEL:PRISMATIC:CLR:2X4 251
255 26261 LENS:14":WHT ACRYL:F/DRUM FIXT 227