Solved

Subform question - MS Access

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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

829 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