Forms and Subforms

juansre

New member
Local time
Yesterday, 16:53
Joined
May 18, 2009
Messages
7
Hi everyone.
I guess that's a newbie question, as that is exactly what I am.
I'm using right now Access 2003.
I've just discovered that I can put subforms in a form.
I'm creating a soccer (football) database, as I want to introduce all games played by my team by a form.
The database is right now this way:
2528267aaa.jpg

I'm making the form by levels. First introducing the basic info for a particular game: Date, Local Team, Away Team (both with combo box pointing to Eq table), and Stadium.
I've introduced a subform with the competition info. I do introduce the IdCompetition in the primary form. and then it automatically takes de value of CompetitionName in the subform.
I've created also a form called "PartJug" where I relate the game with the Player.
Also, I loaded that form into the "Part" form, so now i have it completed.
But the problem is that for both ("PartJug" and "Part") forms, can't fill the data. Everytime is the same: i can't only fill one player, when i fill the second cell, every cell takes the new value.
How can i do this? Any idea?
Thanks in advance.
Is there
 

Attachments

Users who are viewing this thread

Back
Top Bottom