Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-13-2019, 08:23 PM   #1
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
How do I get a subform to pull up multiple records?

Hi everyone,

I need to show a subform in one of my forms that will show how many weeks and the status for each of them. I made a regular status report, but I also want to include a small one on another form. I was able to create the main form with multiple records, but when I try doing it with a subform, I can't. Any advice?

Lkwdmntr is offline   Reply With Quote
Old 09-13-2019, 08:26 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,291
Thanks: 0
Thanked 535 Times in 531 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: How do I get a subform to pull up multiple records?

Not without knowing your data. If you want to provide db for analysis, follow instructions at bottom of my post.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 09-13-2019, 09:32 PM   #3
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: How do I get a subform to pull up multiple records?

Thanks, but I figured it out. Turns out that you can have continuous subforms in the header or footer. So, I just reformatted my original form and it looks great. Thanks any way.

Lkwdmntr is offline   Reply With Quote
Old 09-13-2019, 09:36 PM   #4
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 249
Thanks: 419
Thanked 19 Times in 18 Posts
Tera is on a distinguished road
Re: How do I get a subform to pull up multiple records?

Quote:
Originally Posted by Lkwdmntr View Post
Hi everyone,

that will show how many weeks and the status for each of them.
How many week since when? or up to when?
Are you trying to calculate the number of weeks between two given dates?

EDIT:
It seems that you've found the solution. Never mind this post.

Tera is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull data from unbound textbox on form into multiple records on subform Turn85 Modules & VBA 13 10-27-2016 11:06 AM
Adding multiple records to subform Novice1 General 3 03-01-2016 06:25 PM
Subform generating multiple records Jason Dundas Forms 2 02-17-2015 07:47 PM
Multiple Records in a Subform ccg_0004 Forms 7 05-05-2008 02:23 PM
Multiple subform records and MailMerge bwyrwitzke Modules & VBA 0 05-04-2007 02:14 PM




All times are GMT -8. The time now is 03:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World