Subform troubles

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the user entering team members in a sub form that links to the main
form via a common ID. What I need to do is have the main form determine how
many team members have been entered in the sub form (continuous form style)
and then transfer those names as participants on the main form. Is there a
way to determine the number of sub form entries and who they are? The user
uses a combo box to select the team members and this is populated from a look
up table.
 
Hello Cameron.
I have the user entering team members in a sub form that links to
the main form via a common ID. What I need to do is have the main
form determine how many team members have been entered in the sub
form (continuous form style) and then transfer those names as
participants on the main form. Is there a way to determine the
number of sub form entries and who they are?
The user uses a combo box to select the team members and this is
populated from a look up table.
Click to expand...

I guess that the main form contains team information and the subform
is linked to the main form via a TeamID.
A common way to display the number of subform entries in the main
form is to create a textbox in the subforms footer that contains a
formula like "=Count(*)" (without quotes). You do not have to make it
visible. To display the value in the main form, create a textbox
there and reference the textbox in the subform in the controlsource
propery ("=[subformcontrol].Form![CountTextbox]").
But why sould the main form access the name field of the subform?
The user can see the names in the subform, isn't it? The names of
the team members should be displayed in the combo box.
 
This is going to sound really redundent but the company wants the records
from the main form replicated how ever many times as what there are team
members.

Wolfgang Kais said:
Hello Cameron.
I have the user entering team members in a sub form that links to
the main form via a common ID. What I need to do is have the main
form determine how many team members have been entered in the sub
form (continuous form style) and then transfer those names as
participants on the main form. Is there a way to determine the
number of sub form entries and who they are?
The user uses a combo box to select the team members and this is
populated from a look up table.
Click to expand...

I guess that the main form contains team information and the subform
is linked to the main form via a TeamID.
A common way to display the number of subform entries in the main
form is to create a textbox in the subforms footer that contains a
formula like "=Count(*)" (without quotes). You do not have to make it
visible. To display the value in the main form, create a textbox
there and reference the textbox in the subform in the controlsource
propery ("=[subformcontrol].Form![CountTextbox]").
But why sould the main form access the name field of the subform?
The user can see the names in the subform, isn't it? The names of
the team members should be displayed in the combo box.
Click to expand...
 
Back
Top