I need some advice.
One of the projects I have on the go has a list of names in a database. I need to be able to count the number of times a name appears within the database.
the adodc is named adoPerson.
The names will be in a combo box (called cboPersonSearch)
When someone selects the name the text box will be populated with the number of time the name appears.
combobox person name selected = Fred
textbox text = 36
Can anyone help?
I am away on holiday for the next few days so I will check back later next week.
Thanks in advance guys.