how to display data columns on a form

[C. Morgan]

Please help,

I have a payment form in which I enter bowlers weekly payments. I want to
have a form in which I pick the team number and it will populate all four
team members so that I can enter their payments. I had a combo box to pick
the team number, and that worked fine, but it only gave me one team members
name.
Any help will be greatly appreciated.

Thank you in advance,

Cheryl Morgan

 

[ruralguy via AccessMonster.com]

A Form and SubForm handles the 1:M relationship very nicely. Team on the
Form and the Team Members on the Continuous Form SubForm.

 

[John W. Vinson]

On Sun, 11 Jan 2009 16:09:01 -0800, C. Morgan <C.

Please help,

I have a payment form in which I enter bowlers weekly payments. I want to
have a form in which I pick the team number and it will populate all four
team members so that I can enter their payments. I had a combo box to pick
the team number, and that worked fine, but it only gave me one team members
name.
Any help will be greatly appreciated.

Thank you in advance,

Cheryl Morgan

What's the structure of your table or tables? What I'd recommend is at least
three tables - a table of Teams related one to many to a table of Players,
related one to many to a table of Payments. You could use a form, subform and
sub-subform to enter the data (along with other possibilities).

 

[C. Morgan]

Thank you so much, I forgot about the subforms. I do have the three tables
you mentioned. So I will try to use the subform. The tables are linked as "1
to many".
It has just been awhile since I have used access with forms. I am using
visual studios to do most of it I was trying to have a backup incase I have
issues with vb

Thank you so much.