473,395 Members | 1,762 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Require Report to expand with data entered into subform within my form

Hi Guys, I have a form used to enter data into my mdb and within that form is a subform that expands as I add more records. However, the data that is reflected on the report will not expand to reflect what is on the subform it will only show the last record entered into the subform.
How can i make the cell in the report show what is in the subform (not in one cell as I understand the concept of letting a cell grow).
Jul 4 '13 #1
2 1074
zmbd
5,501 Expert Mod 4TB
Your question is fairly difficult to follow.

Either you have a field that is cutting off data and you want that data to show or you have a series of records that are not showing up as expected on the report.

In the former, you need to set the can grow for the field and possibly the same for the details section; however, from the comment in the parenthesis that doesn't appear to be the issue at hand.

Thus, we come to the expected records not being returned. The report will only show those records that either match the query or are in the table. So you need to start with the datasource for the report.
Jul 4 '13 #2
Many thanks zmbd, Yes the latter seems it may be the way to at least explore the problem, sorry my question was difficult to follow. The subform within my form is used to request pricing for vehicle accessories and as you add a record it adds the next cells to continue adding if required. I then use the data entered to populate a report that is used to e-mail to dealerships for pricing. Everything from the main form populates as it should but only one line from the subform will show on the report it will not expand and show all records. So logically as you say the datasource may be the issue. Thank you for taking the time to respond my friend it is greatly appreciated. I will now examine the source in detail, it is at least a good place to start.
Kind regards Mikey21
Jul 4 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mojca | last post by:
I have a problem with a report of data entered on the current day. Data are enter in a continous form. In this form I have field named Current_date_entered_data – text box which has default value...
0
by: John Baker | last post by:
Hi: I am trying to put together a report that looks like a refrigerator calendar. It will show one line for each week in the month (always starting on a monday). If the month starts on some...
5
by: Ellen Manning | last post by:
Using A2K. I need the syntax to set the recordsource for a subform within a subform. The "main" subform's recordsource changes based on user input. I need to change the recordsource on the...
1
by: Andrew | last post by:
What I'm trying to have done is the following: After data is entered into a form, I want the user to click the "Submit and print" button, which solidifies the data in the tables, then prints a...
1
by: Momo4 | last post by:
I have a unbound main form with unbound fields that correspond to fields on a bound data sheet subform. As you enter data on the subform, the corresponding fields get updated through code (e.g....
3
by: jburris | last post by:
I have been through enough of these threads to think that this should be an easy fix... but, are there circumstances in which the following code syntax does not work? =!!.Form! (this is out of...
6
by: ryan | last post by:
I created in design view a subform within a subform. However the subform within the subform in only visible in design view. In form view the subform within the subform is not visible. I have...
1
by: SadikZ | last post by:
Hi everyone, I want to transfer my data from windows form of Visual basic .Net 2000 to another windows form of Visual basic .Net 2000, but i am not getting the code which i have to write...
5
by: jgarcia187 | last post by:
I have a report that runs based on parameters set in the underlying query. For example, in the "account number" field in the query I've entered in the criteria area. This allows the user to select...
7
by: Deezel | last post by:
I have a many to many relationship between tblResProjData and tblProperty, with tblCHI as junction table. I thought with the 'Enforce Refrential Integrity', and 'Cascade Update Related Fields'...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.