Solved

Change format of subform

Posted on 2016-10-18
3
34 Views
Last Modified: 2016-10-24
I have a blank Access form whose format is single form.

I placed a subform in the detail section of the form.  The subform is tied to one of my tables.  I want to display the subform as Continuous Forms but it won't allow me to.  When I go into the subform's properties, even though the format selection has been changed to Continious Forms, it still displays as DataSheet, which is he default.

What am I doing wrong?  Thanks.
0
Comment
Question by:dbfromnewjersey
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41848672
the subform is not set to allow additions

Data tab of properties: Allow Additions = Yes

> " I want to display the subform as Continuous Forms but it won't allow me to. "

you can change it back if the subform is on a single form ;)
0
 
LVL 1

Expert Comment

by:Peter Cole
ID: 41848673
Have you tried opening the subform in design mode and setting allow datasheet view property to no.
0
 
LVL 19
ID: 41848677
> "which is he default"
just set the Default View property back to continuous for the subform

Access will gripe but you CAN use a continuous subform on a single form
You can also use a continuous form on a continuous form as long as the subform is in the main form header or footer
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question