Solved

Subform question - MS Access

Posted on 2016-10-27
5
22 Views
Last Modified: 2016-11-01
I have 2 subforms on my form. The first one is fine. It has a detail section that allows me to drag controls onto it, etc.  When I created the second subform, it just appears on the form as a big white box.  What am I doing wrong?  Like subform1, I want to be able to put controls on subform2.  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
  • 4
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 41862771
does subform2 have records to display?
0
 

Author Comment

by:dbfromnewjersey
ID: 41862973
Not yet. Because its record source is a temporary table that is currently empty.  I'll ultimately be using subform1 to copy selected records (one by one by use of a command button on subform1) from subform1 (whose record source is a different table) to subform2.

But I need to populate subform2 with some textboxes to display the temporary table data; as I won't be displaying all temporary table fields in subform2. Only selected ones.
0
 

Author Comment

by:dbfromnewjersey
ID: 41863000
I created a new database quickly and put a subform on a form to illustrate what I'm referring to.  Normally when I put a subform on a form, it will initially display with a horizontal and vertical ruler, a header section, a detail section, etc.  And I think even the wizard opens automatically to ask some questions.  Now when I put a subform on a form, all I get is a white box like in the attached.
TestDatabase.accdb
0
 

Accepted Solution

by:
dbfromnewjersey earned 0 total points
ID: 41863004
Nevermind. I figured it out. The Control Wizards was not set to on.
0
 

Author Closing Comment

by:dbfromnewjersey
ID: 41868085
Because I gave the answer.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

630 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