I have a form used to enter parameters for a query that flow through to a report. The parameters for this form/query/report are based on years. I want to build a similar form/query/report for months. I copied the original form/query/and report and changed the name to “Monthly Statement”. I updated the code on the form to refer to the new report, and the criteria in the query to reference the monthly form. When I use the original form it accepts my data but also prompts for the month data, and the monthly one keeps prompting for the annual data. Any suggestions for trouble-shooting this? I’ve managed to break my originals, and my monthly ones don’t work either!
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Copy Parameter Form and Code
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Copy Parameter Form and Code
- This topic has 1 reply, 2 voices, and was last updated 16 years ago.
Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerMarch 12, 2009 at 3:29 pm #1151730It looks like either the forms refer to the wrong query or the queries refer to the wrong form or both – check everything carefully.
If you can’t find the cause, you could create a stripped down, compacted and zipped copy of the database and attach it here (make sure to remove or alter sensitive data).
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Strongbox Password Manager Sold to Applause Group – Cost Escalation Imminent
by
Paul T
1 hour, 39 minutes ago -
SharePoint
by
CBFPD-Chief115
2 hours, 21 minutes ago -
Google replacing Google Assistant with Gemini AI assistant
by
Alex5723
4 hours, 15 minutes ago -
You can no longer stop Alexa from sending voice recordings to Amazon
by
Alex5723
4 hours, 43 minutes ago -
Meeting Woody in person
by
Susan Bradley
15 hours, 43 minutes ago -
Bear with me – getting some options regarding membership
by
Susan Bradley
19 hours, 20 minutes ago -
Difficulty installing Microsoft Office Home and Business 2024
by
Kathy Stevens
41 minutes ago -
HOT NEWS: privacy focused VPN released
by
Microfix
1 day, 2 hours ago -
‘ClickFix’ Phishing Scam Impersonates Booking.com to Target Hospitality
by
Alex5723
1 day, 13 hours ago -
OpenAI urges U.S. to allow AI models to train on copyrighted material
by
Alex5723
1 day, 14 hours ago -
Windows 11 Insider Preview Build 22631.5116 (23H2) released to Release Preview
by
joep517
2 days, 1 hour ago -
Windows 11 Insider Preview build 27813 released to Canary
by
joep517
2 days, 1 hour ago -
Windows 10 Build 19045.5674 (22H2) to Release Preview Channel
by
joep517
2 days, 1 hour ago -
PartWork™ for Windows
by
bbearren
20 hours, 42 minutes ago -
Toll road scams are back: What to do if you get a text saying you owe money
by
Alex5723
15 hours, 23 minutes ago -
Windows update download issue…
by
CAS
11 hours ago -
WUMgr & KB5053602 Update/Install fail
by
dataman1701
1 day, 1 hour ago -
Finding Microsoft Office 2021 product key
by
Kathy Stevens
1 day, 4 hours ago -
Over-the-Top solves it!
by
RetiredGeek
2 days, 19 hours ago -
To Susan – Woody Leonhard, the “Lionhearted”
by
Myst
1 day, 7 hours ago -
Extracting Data From All Sheets
by
WSJon5
3 days, 3 hours ago -
Use wushowhide in Windows 11 24H2?
by
Tex265
1 day, 3 hours ago -
Hacktool:Win32/Winring0
by
Marvel Wars
1 day, 2 hours ago -
Microsoft Defender as Primary Security Question
by
blueboy714
2 days, 9 hours ago -
USB printers might print random text with the January 2025 preview update
by
Alex5723
2 days, 8 hours ago -
Google’s 10-year-old Chromecast is busted, but a fix is coming
by
Alex5723
1 day, 16 hours ago -
Expand the taskbar?
by
CWBillow
3 days, 15 hours ago -
Gregory Forrest “Woody” Leonhard (1951-2025)
by
Susan Bradley
2 hours, 26 minutes ago -
March 2025 updates are out
by
Susan Bradley
20 hours, 22 minutes ago -
Windows 11 Insider Preview build 26120.3380 released to DEV and BETA
by
joep517
4 days, 9 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.