?
Solved

Change format of subform

Posted on 2016-10-18
3
Medium Priority
?
52 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 2000 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 22
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

770 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