J
JL
If I understand your question correctly.
First, to create the drop down list. All you have to do
is to create another query using the one that you create
with the count (that's call it "Query1") and join it back
to the leader table using the lid.
Something like this.
Leader_Count:
SELECT Query1.lid, [leader].[lname] & ", " & [leader].
[fname] AS Leader, Query1.["Follower Count"]
FROM Query1 INNER JOIN leader ON Query1.lid = leader.lid;
This should give you the drop down box that you needed.
Then in the form, all you have to do in your combo box is
to use that "Leader_Count" query as you source.
First, to create the drop down list. All you have to do
is to create another query using the one that you create
with the count (that's call it "Query1") and join it back
to the leader table using the lid.
Something like this.
Leader_Count:
SELECT Query1.lid, [leader].[lname] & ", " & [leader].
[fname] AS Leader, Query1.["Follower Count"]
FROM Query1 INNER JOIN leader ON Query1.lid = leader.lid;
This should give you the drop down box that you needed.
Then in the form, all you have to do in your combo box is
to use that "Leader_Count" query as you source.