Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7864
  • Last Modified:

How to Make an Access subform a continuous Form view

Hi,
I ll like to make an Access subform continuous on a main form so as to view more than one record at a time. But access keeps telling me that "you can't view a form as continuos if it contains a subform..." But i know it is possoble. Just like the one in the picture below. Help please
continuous-subform.JPG
0
peterslove
Asked:
peterslove
  • 12
  • 10
  • 8
  • +1
1 Solution
 
Nick67Commented:
The subform can be continuous -- but ONLY if the main form is not.
So very likely, the main form is presently in a Default View of Continuous Forms.
That must be changed FIRST to Single Form
Then the subform can be changed to Continuous Forms
0
 
petersloveAuthor Commented:
In order for the subform view to look like that in the picture, the subform must be in datasheet view originally before embedding it in a main form. So it cannot be in continuous view then. After embedding in the main form, i need the data to be continuos as can be seen on the picture. There should be a workaround
0
 
Rey Obrero (Capricorn1)Commented:
yes, that is doable..

place your subform in the footer of the continuous form.
accept the complain that the continuous will be change to single form
save the form..

open the continuous form in design view and set the Default view back to Continuous Forms
save
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
petersloveAuthor Commented:
I did just that. There was no error message but the subform is still not continuous. Same as before.
0
 
Rey Obrero (Capricorn1)Commented:
the subform must be be in datasheet view.
0
 
Nick67Commented:
"you can't view a form as continuous if it contains a subform..."
You CANNOT, WILL NOT, and WILL NEVER be able to have a main form set to Continuous Forms if the a subform exists.
That is there error message.
It is very clear, and there is no workaround

Pity, that.  Pined for.  Not happening

The subform can be anything you like.  Datasheet, single form, continuous, whatever
The main form will be single form.  Full stop.
0
 
petersloveAuthor Commented:
Could you look at the attached picture view before concluding on that statement. That is a subform in continuous view
continuous-subform.JPG
0
 
Nick67Commented:
And subforms can contain subforms.
But there, too, the parent must be a single form, and the child anything you like.
single --> anything
single --> single --> anything
single--> single --> single --> anything

Only the final child can be anything
All parents must be single forms
0
 
Nick67Commented:
That is a subform in continuous view
It sure looks like a datasheet.

Show EVERYTHING.
The parent and the subform
0
 
petersloveAuthor Commented:
the subform is in datasheet view
0
 
Rey Obrero (Capricorn1)Commented:
as i said above
a main form (continuous form)
can have a subform (datasheet view) in the footer
0
 
Nick67Commented:
the subform is in datasheet view
Agreed.

Throw the whole nine yard into design view
Click that subform
Scroll it down so that you can right-click completely clear space
Choose Properties
Format
Default View
Set it to continuous forms instead of datasheet

Switch to form view
Save
0
 
Nick67Commented:
as i said above
 a main form (continuous form)
 can have a subform (datasheet view) in the footer


Thanks, Rey
I learn something new every day!
(Not that I'd let end-users have a datasheet, but that's a different story :)
0
 
petersloveAuthor Commented:
Attached is an example of a subform in continuous view just to show that it is possible
continuous-subform.JPG
0
 
Rey Obrero (Capricorn1)Commented:
what you showed in the picture is just  a simple main form/subform set up
and the subform is in continuous form view

that is normal
0
 
Rey Obrero (Capricorn1)Commented:
my comments above was based on your post

< "you can't view a form as continuos if it contains a subform..." >
0
 
Nick67Commented:
We are at cross-purposes.
A continuous subform cannot exist on a continuous main form.
Is it your contention that it can?

A single main form can contain a continuous subform
Rey has said a continuous main form may contain a datasheet subform in the form footer with a workaround

To be an image of a continuous subform on a continuous main form, you'd have to show repetitions of the subform  - which I don't think you will be able to post, because it is impossible.
0
 
petersloveAuthor Commented:
So my question is, how do i get my form to look like that in the picture i just posted.
details:
The subform on the mainform is in datasheet view.

So far i have not gotten any response that worked for me
0
 
Rey Obrero (Capricorn1)Commented:
just create a Main form

drag and drop your subform in the detail section of the Main form

your subform can be in Datasheet or continuous form view

see this demo
https://support.office.com/en-us/article/Watch-this-Create-a-form-that-contains-a-subdatasheet-6a562c4d-f061-4e9b-a533-f08f9a390852?ui=en-US&rs=en-US&ad=US
0
 
Nick67Commented:
Parent form with datasheet subform sample  attached
parent.mdb
0
 
petersloveAuthor Commented:
Hi Ray, i can t access the video on the page, is there another format?
And Nick, i just checked out your Access forms, and your subform should dispay all the records (9 records) you do not have to click next to view the record. Hence continuous view. that is my whole question
0
 
Rey Obrero (Capricorn1)Commented:
0
 
petersloveAuthor Commented:
It works Ray, just as i wanted. Thank you very much
0
 
petersloveAuthor Commented:
works perfect
0
 
Rey Obrero (Capricorn1)Commented:
here is another sample
Database1.accdb
0
 
PatHartmanCommented:
@peterslove,
No one was telling you that you couldn't have a subform in continuous view.  (BTW - your example is datasheet view not contiguous view.)  I didn't try it but several people suggested that you MUST define the subform as a DS and save it that way.  You can't convert it to DS after you embed it.

@Nick,
(Not that I'd let end-users have a datasheet, but that's a different story :)
Why on earth not?  Almost every subform I make is in datasheet view.  In DS view, Access exposes some integrated search options that the users love.

@Rey,
That's pretty cool.DS subform on continuous main form  I forgot you could do that.  I threw a quick form together just to show how it works.  I used the Switchboard items table since that file is hierarchical and so would make sense to display this way.
Typically when I need to do this, I use two DS forms on a main form.  The first DS controls the second.
0
 
Nick67Commented:
your subform should display all the records (9 records)

No, no it should not.
It is set to datasheet view of all records where NumID and Num match
It could be set to Continuous Forms view of all records where NumID and Num match.

Now, it seems your true question was "I'd like to add a subform to my main form that has no master/child relationship so that the subform displays all its records regardless of what is happening on the main form"

You seem to have discovered the answer to that question.  If the main and subform have no Master/Child field relationship, the continuous subform will display all records
0
 
petersloveAuthor Commented:
Good tip thanks
0
 
Nick67Commented:
Why on earth not?
Data control.
Our app has the users entering data, images, and files
Once entered correctly, nothing changes; no deletions, no updates
The data is not of the kind that an Excel-like view is of much use.
A datasheet view presents a wide, hard-to-control view of data that presents umpteen million opportunities for users to inadvertently change data without the requisite events needed to cut that off at the knees.

I'll pass

Continuous forms are similar, but all the control events respond as expected.
And then there are reports :)

People see things that look like Excel and start to treat them like Excel.  That hasn't worked out well for us.
0
 
PatHartmanCommented:
Data control.
A DS form is just a form with a different view.  There is nothing different about events or what you can do to protect data.  You seem to be confusing a form in DS view with a query, probably because they look the same.  The difference of course is that a form gives you the events you need for data control and the query gives you NO control.  So, yes, I NEVER give the user a query to work with but they frequently get data sheets.

Just FYI,  DataSheets work best as subforms.  That allows you to use an unbound main form for headers and search criteria which is what peterslove appears to want to do.

This is an example of an unbound main form with a DS subform.  All the fields in the header are unbound and are used to filter the subform.  Clicking on the Client Name field opens the client record where it can be edited.  Clicking on the Service field, opens the service order that was rejected.
DS subform
0
 
Nick67Commented:
@PatHartman

You seem to be confusing a form in DS view with a query
LOL.  You know me better than that already.  I didn't fall off the turnip truck!

There is nothing different about events or what you can do to protect data.
There was.
I have, and still do, develop primarily in A2003.  I won't speak for uplevel versions, but I have noted events that fired reliably in Single or Continuous forms views not firing in Datasheet view.  And in my setup, that absolutely cannot happen so datasheet views are verboten.  There's lots of things happening on GotFocus and AfterUpdate that need to go on, there are command buttons that need to be seen, there's formatting to indicate that a useful and consequence-free double-click event exists and datasheet views potentially monkey with it all.

And it's not data that an Excel-like view is useful for anyway.  You're sellin'  I ain't buyin' :)
0
 
PatHartmanCommented:
A datasheet view presents a wide, hard-to-control view of data that presents umpteen million opportunities for users to inadvertently change data without the requisite events needed to cut that off at the knees.
I've been using Access since 2.0 and haven't experienced any event differences.  There are certainly formatting differences but that has nothing to do with data integrity or validation.

I work as a consultant so every new app is an adventure and an opportunity to learn how yet another company operates.  Apparently my data view is wider and more varied than what you see since I am not constrained to one company or one version of Access.  I guess we'll have to agree to disagree on the usefulness of DS view.
0
 
Nick67Commented:
With the right kind of data and the right kind of user it can make a hell of a lot of sense.
I'm not at that intersection, though.
I have a single form frmExcelLikeView that would have been a candidate for a datasheet view.
And if I had realized that plonking it on a form as an unbound subform would have permitted the architecture of the form to remain, I might have worked much harder around the datasheet's idiosyncrasies -- but that's water under the bridge.

I have a mixed environment of A2003, A2010 and A2013.  With a half-million lines in a single app, and a thorough-going boatload of existing objects, A2003 remain by far the most productive platform for me to develop on.  If the help system weren't so poor and my dependence on bringing the properties window from a right-click so great, I'd consider moving to A2010
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 12
  • 10
  • 8
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now