count in combobox

[kingofkabul]

Dears,

Can you tell me how to apply count function on a combo box in a query?
for example i have table with a drop down field named Programs and it
consists (under graduate, graduate, post graduate) i want to count the
under graduate records based on the above mentioned combo box.

Can I do it so?

Naweed

[Steve]

Dear Your Highness:

Assuming your combobox is on a form named Prince, the name of your combobox
is TheRoyalCombobox, the rowsource of your combobox is a value list of under
graduate, graduate and post graduate and the name of your table is
TheRoyalTable, use:

CountOfRecords = DCount("*","TheRoyalTable","[Programs] = '" &
Forms!Prince!TheRoyalCombobox & "'")

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com



<ki*********@gmail.comwrote in message
news:11*********************@q66g2000hsg.googlegro ups.com...

Dears,

Can you tell me how to apply count function on a combo box in a query?
for example i have table with a drop down field named Programs and it
consists (under graduate, graduate, post graduate) i want to count the
under graduate records based on the above mentioned combo box.

Can I do it so?

Naweed