Help

[outandabout24]

I am having problems with this.. can someone help?



I am trying to create a text box that when a person enters the players name counts the number of players that have been entered. This would also count the number off all players from all teams not just the team that is displayed. Can anyone help? I am not good with Access.. I am just trying to help someone out because I have a little experience. Thanks all!

Hope that made sense.. so if I have three teams.. one with 10 players names, another with 5, and I am entering in another 5 in the third team, the text box on the form would diplay 20. If I enter in another player it would be 21.. etc... Thanks all!

[Guus2005]

In order to do this you need to program an event of the textbox. For instance the lostfocus event of the textbox.

private sub txtName_LostFocus()
    me.txtAmount = dcount(...)
end sub

HTH

PS didnt look at your database yet.

[outandabout24]

What would go inside the dcount?

[Guus2005]

What would go inside the dcount?

try F1.
It depends on the fieldnames and tablenames you use.