By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Duplicate data showing in main form.

100+
P: 111
I am working with SQL server 2005 backend and Access 2003 frond end.
I have a form bound to a table tblReportDetails. 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=frmParamerer!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.
Feb 26 '10 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
You need to provide more detail...there is no way anyone can work out what is wrong from that description.
Feb 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.