Hi all
Is it possible to have 2 subforms on a form but have the second subform
linked to the 1st subform. I will explain the situation.
My form contains details of teams and the shift the team is working on a
particular day. The 1st subform contains the names of the team members.
As the user moves through the records on the main form, the team members
are updated accordingly. The 1st subform is a continuous form.
I want the second subform to show any absences for the team member
selected in the 1st subform.
I think you are all going to tell me that the 2nd subform should be a
subform of the 1st subform. However, when i tried that i got a message
saying this was not possible with a continuous form. The reason i want
the 1st subform as a continuous form is because i want the user to be
able to select more than one team member at a time and add an absence or
shift change - rather than having to do this one team member at a time.
Hope this makes sense and would be grateful for any help.
thanks
michelle
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!