Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Subform question - MS Access

Posted on 2016-10-27
5
Medium Priority
?
25 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

877 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