470,863 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,863 developers. It's quick & easy.

Trouble with subform showing too many records

I have a main form based on "tblmonth" which has a control "txtmonthlabela"
(based on a field of the same name) My subform based on a query
"qryFDAsubform" which is based on my table "tblmaintabs" has a field
"txtmonthlabel" which connects it to the main form and also a combo control
called "txtcompany" which is based on a field of the same name from my table
"tblmaintabs" to identify the data..
The sub form shows data for companies who submit figures for the month. Some
companies don't submit data every month. However as I run through the
records my subform shows the company name whether or not they have submitted
data. I only want the data to show for a company in any one month if they
have submitted data.
Can anyone point me in the right direction?
Nov 13 '05 #1
0 1035

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Ray | last post: by
1 post views Thread by andrewbda | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.