Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey All,

I have created Tables and Queries. One Queries with a field Criteria :
=[form]![FmProposal Date]![StartDate] And <=[form]![FmProposal Date]![End
Click to expand...
Date].
This form is link to the qurries and the form is link with the report.

When I open the Queries and Forms there is this Error Message that occur
"Enter Parameter Value" that require me to fill in the data. No data is
capture by Access that fall between this period.


What I wish to obtain?

I wish to create a form that have a Start date and End date that can draw
the date from the queries for normal user to key. But I am unable to link the
queries and form together. There is always this error message that occur
"Enter Parameter Value".

I really appreciate your Professional Advise as I may have missed out
certain minor criteria that is required for execution of this function.


Thank you very much
 
You are missing the S from "Forms" in your query:
=[formS]![FmProposal Date]![StartDate] And
Click to expand...
<=[formS]![FmProposal Date]![End Date]

You may still have a problem when the form first opens, if the query tries
to load the records for the form before the text boxes have a value.

An alternative is to leave the criteria out of the query, and use a
WhereCondition to open the report. Details in:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Doris Tan said:
Hey All,

I have created Tables and Queries. One Queries with a field Criteria :
=[form]![FmProposal Date]![StartDate] And <=[form]![FmProposal Date]![End
Click to expand...
Date].
This form is link to the qurries and the form is link with the report.

When I open the Queries and Forms there is this Error Message that occur
"Enter Parameter Value" that require me to fill in the data. No data is
capture by Access that fall between this period.


What I wish to obtain?

I wish to create a form that have a Start date and End date that can draw
the date from the queries for normal user to key. But I am unable to link
the
queries and form together. There is always this error message that occur
"Enter Parameter Value".

I really appreciate your Professional Advise as I may have missed out
certain minor criteria that is required for execution of this function.


Thank you very much
Click to expand...
 
Back
Top