473,503 Members | 1,787 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

subform printing

I have a report which itself is 3 subreports. It was working fine a
couple of days ago, but now when I view the report and then click on
print the parameter questions asking for a date range pop up again.
Wouldn't be so bad except that I have to put the dates in 3 times (1 x
for each subreport)

Is there a way to only ask for the dates 1 x?

How can I get it to stop asking for the dates and just print?
Thanks,
Peggy Fiorentino

Nov 13 '05 #1
3 1861
to fill in the dates in the two other controls:
use the AfterUpdate event to assign the value of the first control you
use you input the date range, to the two other controls.
George Marselis

Nov 13 '05 #2
to fill in the dates in the two other controls:
use the AfterUpdate event to assign the value of the first control you
use you input the date range, to the two other controls.

you might want to do the same thing for the other two controls, ie,
each control should update the value of the other two. that way you can
keep the date current on all three forms, each time you change the date
in any one of the three controls.

George Marselis

Nov 13 '05 #3
Thanks George, how do I do all this exactly. I'm using Access 97 and I
have no experience building events.

Peggy

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4725
by: Tim Graichen | last post by:
Hi! I have a subform (ShedTableSubForm) at the bottom of my MAIN form. I would like to do two things. 1) preview on screen a report (ShedReport) of the subform data the record currently...
4
8432
by: John Baker | last post by:
Hi: I have a form, which contains a sub form (Employee main record and payment record). It all shows up fine in a screen view, but when I come to print it I find that I cannot get the sub form...
0
1052
by: Paul via AccessMonster.com | last post by:
I have on main form and three subforms. When I am printing mainfrom, the datas in subform are showing in the monitor but it's not appearing in printout. The subform lines and labels are are...
4
5073
by: Spencer Lee | last post by:
Hi all, I really need some helps. I created a main form("category"), which contains a subform1, "Part". Inside this subform also has contains a subform2, "Inventory". The second level of...
1
2666
by: kkrizl | last post by:
I have a form that displays general information about an alarm permit location. There's a subform that shows detailed information about burglar alarms that have gone off at the location. When a...
3
5370
by: paquer | last post by:
On my Main form I have a Command Button that opens a Subform in order to create a new Subform record. At this point I want the subform to show only the new record being created. Not all the...
8
1948
by: Christina123 | last post by:
Currently working with Microsoft Office 2000 and whatever version of Access came with that. I am developing a database to track the comings and goings of shared tools. Everything works...
4
7551
by: Orv | last post by:
I have a search form which contains a non-linked subform. When I fill the criteria of my search and click the search button it returns the results in the subform, datasheet view. I then want to...
3
2485
by: Dave | last post by:
Hello! What's the best way to make a button print *just* the selected (displayed) record of a subform, when that subform is currently part of a larger form? Thanks!
3
3886
by: sconard | last post by:
I have a subform in datasheet view that is the result of a complex vba custom query with a number of parameters. I would like to place a button on the parent form to print the datasheet view as a...
0
7199
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7074
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
7322
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7451
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...
1
5000
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4667
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3161
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3150
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
731
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.