Create form that manages Players.

[Grimm]

Hi All. I had a couple questions. I was trying to create a form that has a List box with a list of players from a table of a player pool. My plan was to go through that list. Then when i select a player from the list. I can add it to the blank text boxes above.



Another question i had, was could i create a button to trigger a new set of blank boxes to allow for the addition of another player much like I mentioned above.

To make it clear how it looks like, here is a picture. Thanks.

http://www.mediafire.com/i/?c2ikwjvw9bnekd4

[maximus]

Suppose I have a list Box List1 and TextBox1 to assign the value of the ListBox to the text Box I would put the code on the afterUpdate event:

Me.Text1=Me.List1

remember while assigning the value of the list box to a another form control like TextBox, Combobox you have to remember that the value of the first column is assigned;

Example the RecorSource of a List Box is a query with Column EmployeeID and EmployeeName. The EmployeeID is the First Column so in the case when you select a record in the list box the value of EmployeeID is assigned to the Text box to assign the EmployeeName that is the second column you have to give reference to Column Index:
Me.Text1=Me.List1.Column(1)

Remember the Column Index starts from 0 that is the first column is 0 the next 1

to open a new record use this code in a command button

DoCmd.GoToRecord , , acNewRec