setalley
asked on
Continuous form with a subform
I'm trying to create a continuous form with a subform. I know it's not technically supposed to be feasible but I've found some users who have come up with workarounds. Unfortunately, placing my final form in the footer of the continuous form won't work for me since I need them to be side by side. I've also tried placing the forms next to each other on the other form...but can't get that to work either (I don't think I'm setting up the relationships correctly or something??). So, I'm attaching my database in the hopes that someone can assist me - or at least point me in the right direction.
In the attached database, see the "ProjectFrm" form. This is how I would like the end form to look - but just need the [Actions] form to be continuous instead. So, for each MILESTONE, I would like to have all of the ACTIONS...and then all of the PARTICIPANTS for each of those ACTIONS.
Thank you for your assistance. Regards, Stacy
SurEngList.ZIP
In the attached database, see the "ProjectFrm" form. This is how I would like the end form to look - but just need the [Actions] form to be continuous instead. So, for each MILESTONE, I would like to have all of the ACTIONS...and then all of the PARTICIPANTS for each of those ACTIONS.
Thank you for your assistance. Regards, Stacy
SurEngList.ZIP
ASKER
MX,
Thanks for the response but I'm still not getting it to layout as I'd like. Did you have a chance to look at my attachment? I tried using your steps on the "ProjectMilestoneFrm" form...placing my "MileStoneActionsFrm" form in the footer. Problem I'm still having is that I need my "ActionParticipants" form to be next to my "MileStoneActionsFrm" form. So, since I need it next to it, and not below in footer or above in header, I'm stuck as to how to make your solution work. Or, is it not possible?
Thanks!
Thanks for the response but I'm still not getting it to layout as I'd like. Did you have a chance to look at my attachment? I tried using your steps on the "ProjectMilestoneFrm" form...placing my "MileStoneActionsFrm" form in the footer. Problem I'm still having is that I need my "ActionParticipants" form to be next to my "MileStoneActionsFrm" form. So, since I need it next to it, and not below in footer or above in header, I'm stuck as to how to make your solution work. Or, is it not possible?
Thanks!
ok ... I will look at it tonight ... have to finish some work right now. Ping me later ...
mx
mx
ASKER
Great, thank you so much!
ASKER
Still hoping someone out there can assist? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That makes sense...thanks so much for the response. I may revisit the current layout to see if I can make use of the solution you provided previously. Best Regards.
"Grade: A - "That makes sense...thanks so much for the response. I may revisit the current layout to see if I can make use of the solution you provided previously. Best Regards."
You are welcome.
mx
You are welcome.
mx
****
OK ... first ... yes, it can be done ... been doing it for years.
Just note that you won't be able to put a continuous (sub)form in the Detail Section of another Continuous form ... but, you can ... after the stupid error ... do it, as such:
ok ... Set your main form's Default View to Continuous ...
Drag a Continuous subform into the Header or the Footer of your main continuous form.
You will get the error message:
"A form with a subform object can't have its Default View set to Continuous Forms."s
...and Access will RESET the main form's Default View to Single Form.
Now do this - in the exact order shown:
1) CUT ... (Control X) the subform off of the main form.
2) Set the Main form's Default View back to Continuous Forms now.
3) PASTE the subform back onto the main ... and you s/b good to go.
4) Save your main form (with subform).
I've done this many, many times ... since Access 2.0
No clue why M$ does not 'allow' this?
Then ... you can repeat 1-4 for more 'continuous' subforms ... again ... only in the Header and/or Footer, not the Detail section.
Note ... You can ... drag a continuous subform into the Detail section of the main form ... and go through steps 1-4 ...but, when you open your main form ... you will get that same message again ... and the main form's Default View will be reset back to Single Form. I have not found a way around this .. BUT ... really, you WANT the main form to be Continuous ... so, the Detail section needs to be available anyway, so this is not really a problem.
mx