Count cascading combo records

[Steven811]

Hi

I have a simple form with 4 cascading combo boxes that are sourced through queries and work fine.

To help the user I want to display a record count as a record from each combo is selected. I searched the archives and using my own initiative came up with something that doesn't work, so now I'm stuck.

In the control source of an unbound text box I inserted the following:

=Count([me.mycbo(2)])

It returns an [#error] message.

Can some one help.

Steven811

 

[pono1]

Steven,

Try searching on DCount here and in the Help File...

Regards,
Tim

 

[ansentry]

If you want to display the record count of a combo box or list box then on your form put and unbound text box, and make the control source

=[mycbo].[ListCount]


Regards,

 

[Steven811]

Thanks

Works a treat, thanks.