Help with a Form

[outandabout24]

Can Any one help with the attachment... I am trying to have the user input a team name and under that team name enter the players to that team. Once they enter the player name... there is a txt box to the right that the name appears in.. I want the user to be able to enter more then one name in and have it displayed in the large txt box. Also this information would be attached in the table so that If I wanted to view team eagles I would see all the players in a table format... can anyone help???

 

[JPaulo]

Hi friend;

See sample in attc;

 

[outandabout24]

I like it... works great!! Thanks a ton.. I was actually wondering sort of the opposite though..

So in the box you have team name... I would enter the team name in the form view such as eagles or whatever i wanted...
Next I would enter in the players name in the text box (text box 1)beside the team name that you created...

The big box that you have that already has names populated, this would be blank
Then when I enter a players name into the text box 1 and click a button or click enter then they would appear in the big box..

If I entered a new team name... the big box would be blank so I could enter the players name for the new team..

 

[JPaulo]

See in attc;

 

[JPaulo]

See in attc;

 

[outandabout24]

Works like a charm! I am going to dive into it and learn from it.. hope u don't mind if I ask why you did what you did so that I can understand..

 

[JPaulo]

Thanks for replay.

There is nothing special, see the structure.

Please, delete the report and module that do not belong to this example, sorry.

 

[outandabout24]

I have a couple of questions..

1. What does the "on got focus" do? I did my own and I couldn't get it to work until I put the code into "on got focus".
That code is
Private Sub Command4_GotFocus()
Me.txtPlayer.SetFocus
End Sub

2. How do you get the form to pop up when you click on team II form? When I made mine everytime I click on my form a table comes up, I don't even use this table. Then I have to click on form view to get my form to come up. I know this is elementry.

3. What if I wanted to do a count display for the amount of players I have for that team? What if I wanted to do a count display for the total amount of players I have on all teams? IE two txt boxes that one displays how many teams members are on the team that is currently viewing and another one that shows how many total players are on all teams? Would it be better if I started a new thread for this one?

4. Sorry.. How do I delete the report and module that does not belong in the example.

You have been a great help!