Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Multiple subform usage

Author  Topic  dpac Starting Member 2 Posts Posted - 2005-10-26 : 17:58:02 Hi! i'm currently workin on a project that requires me to create a SEARCH FORM. The database consists data from 5 different cities. Each of these cities are accessed using seperate queries. There are 5 fields that are used to access the records explicitly. I'm using a fuzzy logic technique to access the records. Example of one city is given below SELECT Hawaccsumm.BUS_ID, Hawaccsumm.BUS_NAME, Hawaccsumm.SITE_ADDR, Hawaccsumm.SITE_CITY, Hawaccsumm.SITE_STATE, Hawaccsumm.SITE_ZIP, Hawaccsumm.[PH #1], Hawaccsumm.license, Hawacchis.[Transaction Date], Hawacchis.[Charge Code], Hawacchis.Units, Hawacchis.[Charge Year], Hawacchis.[Charge Amount] FROM Hawaccsumm, Hawacchis WHERE (Hawaccsumm.BUS_ID Like "*" & Forms.Form1.Text2 & "*") And (Hawaccsumm.BUS_NAME Like "*" & Forms.Form1.Text5 & "*") And (Hawaccsumm.SITE_ADDR Like "*" & Forms.Form1.Text8 & "*") And (Hawaccsumm.[PH #1] Like "*" & Forms.Form1.Text10 & "*") And (Hawaccsumm.SITE_ZIP Like "*" & Forms.Form1.Text15 & "*") And (Hawaccsumm.BUS_ID=Hawacchis.[Account Number]) ORDER BY Hawacchis.[Transaction Date]; I'm required to display the results in a subform. But since each CITY has a seperate query to access its records, I cant use one subform. So i created 5 subforms to display the results of each city seperately using a combo box in the main form. My problem is, How do I display each subform by itself i.e. Supposed i select HAWTHORNE in the combo box(the above written query is for hawthorne), it displays the result in its respective subform BUT the other forms are also displayed. I want only the required form to show up, while the other subforms stay invisible. PLzz help me out. Derek