Display Number of Records in a Filtered Form 1

[RobotMush]

I have a form with a combo box to choose how you want the data to be displayed. I.E. if Certain Last Name is choosent the only those records with the Certain Last Name will be shown. This works very well. However, I am wanting to be able to show how many records there are of the Certain Last Name filtered form. I.E. is it 3 records, 6 records, No records? How would I do this.

Thank you for your help

RobotMuch (Technical User)

 

[FoxProProgrammer]

Where do you get the data for the combo box? If it is from a Query, try the following in the On Click event procedure of the combo box.

[yourRecNumCtrl.Value = DCount("fldinQuery", "Queryname")

dz
dzaccess@yahoo.com

 

[Pampers]

You can put the record navigator on your form, and it will show how many records are filtered.

Pampers
There is only one way to change a diaper - fast

 

[TheAceMan1]

or . . . in the [blue]ControlSource[/blue] of an unbound textbox:

[blue] =Recordset.RecordCount[/blue]

See Ya! . . . . . .

 

[RobotMush]

Thank you Pampers, That is what I am wanting to do but I do not know how to do it.

TheAceMan1, once again you have helped me greatly by giving me just the info I need to be able to start to work and play with the information and therefore learn what I need to know and how to implement it.
Thank You

RobotMush (Technical User)