Solved

Subform question - MS Access

Posted on 2016-10-27
5
15 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
  • 4
5 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now