Filter and Drag....

Hi, Download the sample database: [login to view URL] NOTE: I DID ALL THE COSMETIC WORK ON THE FORM, SO ALL YOU HAVE TO IS TO CODE (VB OR VBA PORTION) I have form and it loads query, user can select field and export the data into an excel file. and It works. I need to get some enhancement done. Open the database and you will see two forms. frmlocalauthorityquery is the new one. and frmlocalauthorityquery-old is the old one. they both work. New one has all the new feature that i want to implement (but not working) and old one does not. Data gets loaded from a query. I was wondering if I can put additional filtering system. You can open the form "frmLocalAuthorityQuery" and select the query from the combo box, then highlight fields in the box and export. > Field moving from box to box is not working > Filter by is not working (dept gives the whole data) (mgr gives data by manager, a combo for mgr pops up, cbotl hides) (Team gives data by team_leader, mgr combo hides and cbotl pops up) > I would like to filter the data by year (like 2000, 2001 as well as latest records) look at the query and you will know what i am talking about. > Instead of loading a query in "cboQuery" combo box, I was wondering if I can populate this box with 4 or 5 different tables. These tables are link (using some primary keys). End user should be able to select multiple fields and then the list box should populated all the fileds from both tables (tables that end user selects) Any suggesstions or help will be appreciated. By the way, I dont have upper version of Access, so DONT ASK. If you have to post a database please put it in Access 97 version. My budget for this project from $10.00 to $15.00. Please dont bid somthing BIG, I will delete you right away. Thanks