enter parameter value error

Posted on 2009-05-26
Medium Priority
Last Modified: 2012-05-07
I have a Report with 2 sub reports attached to it , when i try to open the report from the form using the open report button i am asked to enter parameter value for "Date" whereas i dont have a date field anywhere in all of my 3 tables or in my 3 queries.....if i just press enter it shows me the report just fine

the main report is based on this query
SELECT * FROM tblcorp WHERE ((tblcorp.tradingaccno)=[Forms]![frmcorp]![tradingaccno]);
this shows me the current record in the report view

the other 2 subreports are based as follows
SELECT * FROM tblcorpcomm;
SELECT * FROM tblcorpsalesper;

Question by:samipk
  • 4
  • 3
LVL 75
ID: 24480188
Things to check:
Group and Sorting dialog for left over 'Date' as a Grouping or Sorting field.

Any control on the report that may have 'date' as the control source - accidentally.

A conditional Formatting expression using Date ....

Make a back up copy of your report ... then start deleting controls ... until you find the offending control.

Also ... linking fields to the sub reports.

LVL 42

Expert Comment

ID: 24480198
Run each query independently.  Are you still prompted for date?

Author Comment

ID: 24480307
@DatabaseMX: i just have order by on load set to yes and nothing else
all the record sources just point to the queries
i dont have any conditional formating
by controls you mean records or command buttons like add record etc? i have tried deleting record from all of the subforms but that didnt help...i also tried adding data but that didnt work either

@dqmq: no i am only prompted for the tradingacno in the main query i am not prompted for any date in any of the queries
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

LVL 75
ID: 24480333
"by controls you mean records or command buttons like add record etc? i"
"all of the subforms"

You mean sub reports, right ???

Controls = text boxes on reports.

Somewhere on the report (or possibly in the query - but apparently not) ... the word Date is either a Control Source or part of some expression.


Author Comment

ID: 24480403
one more thing i figured out i have the following code attached to the record source of the main form

SELECT tblcorp.*, tblcorpsalesper.tradingaccno AS tradingaccno_tblcorpsalesper, tblcorpsalesper.changedate, tblcorpsalesper.oldsalesperson, tblcorpsalesper.newsalesperson, tblcorpsalesper.reasonforchange FROM tblcorp LEFT JOIN tblcorpsalesper ON tblcorp.tradingaccno=tblcorpsalesper.tradingaccno;

when i tried to change it to just  tblcorp it started to prompt me for Forms!frmcorp!tradingaccno as well although there is a value in that field
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 24480429
Not seeing a problem there. If it's prompting for 'date' ... then 'date' exists somewhere ... as I indicated above.

Can you convert to A2003 and upload ?

1) Compact & Repair (*** to shrink the size),

2) Zip up the MDB (*** to further shrink the size)

3) Attach the file for upload here (using the 'Attach File function below) ... removing any sensitive data of course.

4**** And please give a clear explanation of exactly how to reproduce the problem or what you are trying to do.

Author Comment

ID: 24480439
ok i found the culprit on a subreport one of the field(changedate) had its name accidently changed to Date that it why it was prompting me
LVL 75
ID: 24480445

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

624 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