I am working with SQL server 2005 backend and Access 2003 frond end.
I have a form bound to a table tblReportDetail s. There are several(5) tabs on the same form. Each tab has its own subform. Every other subform works fine but the very first tab has a subform which shows three cascading comboboxex, cmbCounty, cmbTownship, cmbQuad. cmbTownship and cmbQuad shows values based on the county selected in cmbCounty.
One record from the main form can have multiple combinations of county, township and quads.
During the data entry it works fine. I copied the same form changed its recordsource to make it work like Search form. There is one parameter form which asks user to enter County.
Now, suppose I enter County=Adams. I should see one record in the main form and related multiple combinations in the subform.
Where should I write query condition like "County=frmPara merer!County"
I tried to write it in the recordsource query but it shows duplicate data. For ex. If Record 1 has 5 combination with same County(Adams) , it shows total searched record as 5. It should show only one record: Record 1 and in the subform 5 combinations.
Please help.
I have a form bound to a table tblReportDetail s. There are several(5) tabs on the same form. Each tab has its own subform. Every other subform works fine but the very first tab has a subform which shows three cascading comboboxex, cmbCounty, cmbTownship, cmbQuad. cmbTownship and cmbQuad shows values based on the county selected in cmbCounty.
One record from the main form can have multiple combinations of county, township and quads.
During the data entry it works fine. I copied the same form changed its recordsource to make it work like Search form. There is one parameter form which asks user to enter County.
Now, suppose I enter County=Adams. I should see one record in the main form and related multiple combinations in the subform.
Where should I write query condition like "County=frmPara merer!County"
I tried to write it in the recordsource query but it shows duplicate data. For ex. If Record 1 has 5 combination with same County(Adams) , it shows total searched record as 5. It should show only one record: Record 1 and in the subform 5 combinations.
Please help.
Comment