Solved

Subform question - MS Access

Posted on 2016-10-27
5
14 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

760 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

16 Experts available now in Live!

Get 1:1 Help Now