enter parameter value error

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;


1.JPG
LVL 6
samipkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.

mx
0
dqmqCommented:
Run each query independently.  Are you still prompted for date?
0
samipkAuthor Commented:
@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
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"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.

mx
0
samipkAuthor Commented:
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
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
samipkAuthor Commented:
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
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
excellent.  
mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.