Criteria issue with DCount

[JimO]

I have a list box to select a list winners using a combo box. Everything works a it should so far. I want to add a count of the number of winners in the selected list using DCount. I can't get the criteria to work.

The first expression works and gives me the total count in the table, the second one is the one I want to count only the selected records but I get an #Error, ans I have not been able to resolve the issue.

=DCount("[Winner]","F1PoleT")

=DCount("[Winner]","F1PoleT","Winner=" & [WinnerCmb])

Thanks
Jim O

[aytee111]

The criteria will be the same as the criteria used in the row source for the list box.

Is this in the Control Source of a textbox? If so, it need to reference the form:
Forms!Formname!cmbWinner

[JimO]

There is no specific criteria for the list box.

SELECT [PoleTImeID], [RaceDate], [Winner], [Const], [Race] FROM F1PoleT ORDER BY RaceDate;

Jim O

[aytee111]

I have a list box to select a list winners using a combo box

How does the list box tie in to the combobox?

[JimO]

My mistake the criteria was in the como box event.

I am no sure how to use it in the expression.

WHERE [Winner] LIKE '" & Me.WinnerCmb & "'

Jim O

[aytee111]

Where is the expression being used?

[JimO]

It is in a combo box [WinnerCmb] as an after update event to select the list.

    WinnerList.RowSource = "SELECT [PoleTImeID], [RaceDate], [Winner], [Const], [Race] FROM F1PoleT WHERE [Winner] LIKE '" & Me.WinnerCmb & "' ORDER BY RaceDate;"

Jim O

[aytee111]

I meant, for the DCount, the one mentioned in post # 1.
(Did you see post #2 edited?)

[JimO]

This is what I have for the expression and I get a #Error.

=DCount("[Winner]","F1PoleT","Winner=" & [Forms]![F1WinnersListF]![WinnerCmb])

Jim O

[aytee111]

In other posts you have showed that your combobox is a text field, so you need quotes:

=DCount("[Winner]","F1PoleT","Winner='" & [Forms]![F1WinnersListF]![WinnerCmb] & "'")

[JimO]

That is what I need. Thank you so much for the help (all who responded). As a relative beginner with Access I appreciate the time an knowledge on this page.

Thanks again.

Jim O