The only problem like that I've run into was when the form controls were
based on calculations. In Access 2000 and 2002, it does not seem to be
reliable to refer to the value of a calculated control. I've even seen the
occasional instance where an unbound control might not return a value if
there was a calculated control on the form with an error. Could any of
this apply?
Another problem I've seen that's (not specific to a particular Access
version) arises when the data type of a query parameter is not
automatically determined correctly. Try explicitly adding your
form/control reference to the query parameters, and specify the data type.
On 14 Sep 2003 21:48:47 -0700,
ke*********@eds.com (Ken Lindner) wrote:
We have a report based on a query that is called from a form. Nothing
too special here.
The query has 3 coulmns that are populated directly from values
entered into entry fields on the form that calls the report using
syntax such as "StartDate: [Forms]![frmRunRprts]![tbECHStartDt]" in
the field value of the column. This also reads as
"[Forms]![frmRunRprts]![tbECHStartDt] AS StartDate" in the SQL design
view.
Under Access 97 this returns values to the query result set and as a
result the values appear on the report.
Since upgrading to Access 2000, these columns are left empty in the
query result set.
Has anybody come across this and what was your fix.