UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Subform In Continuous Form, Access 2016    
 
   
dedex13
post Jun 21 2019, 01:14 PM
Post#1



Posts: 2
Joined: 21-June 19



Hello,

Is there any way around the "no subform in a continuous form rule"? I'm trying to set up a data-entry form like this:

Student Information
Information for parent/guardian 1
Phone numbers for parent/guardian 1
Information for parent/guardian 2
Phone numbers for parent/guardian 2
Etc...

I have separate tables for students, parents, and phone numbers and want to be able to enter/view all the information on one screen.

Thanks!
Go to the top of the page
 
theDBguy
post Jun 21 2019, 01:22 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,081
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Welcome to UtterAccess!
welcome2UA.gif

The only workaround I knew of is to place the subform in the footer section of the continuous form. Not sure if that would be good enough for you though. Good luck!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
missinglinq
post Jun 21 2019, 01:58 PM
Post#3



Posts: 4,629
Joined: 11-November 02



As DBguy said...The workaround for having a Subform when the Main Form is in Continuous View requires that you put the Subform either in the Header or the Footer of your Main Form. To escape the wrath of the Access Gnomes, who will tell you that you cannot have a Subform in a Continuous View Form... you have to:

  • Create your Main Form in Single Form View
  • Place the Subform in Header or Footer, whichever you like
  • Save the Form
  • Now go into Properties and change the Main Form's Default View to Continuous View Form

Linq ;0)>

--------------------
Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
dedex13
post Jun 24 2019, 08:24 AM
Post#4



Posts: 2
Joined: 21-June 19



Thank you, the sub-form in the footer won't give me quite what I'm looking for. I guess I'll just have to have one form for entry and another for viewing.
Go to the top of the page
 
theDBguy
post Jun 24 2019, 10:45 AM
Post#5


Access Wiki and Forums Moderator
Posts: 76,081
Joined: 19-June 07
From: SunnySandyEggo


Unfortunately, what you were asking to do was a limitation. If you tell us what you're trying to accomplish instead, maybe we can give you an alternate solution.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th August 2019 - 06:32 AM