Prev: Parsing a string problem
Next: Tables: Appending Data, Link or Not to Link, That's My Question...
From: Basenji on 30 Apr 2010 11:26
Using Access 2003 a form has been created with a combo box to select the name
of a practice. The criteria row in the query shows the form information. When
the command button in the form is clicked to run the report the report runs
with the labels appearing from the underlying query but does not show any of
the detail information. What am I missing in the setup of the form or
elsewhere?
From: Daryl S on 30 Apr 2010 12:53
Basenji -

It sounds like there are no records that match the criteria you are using.
Post your SQL statement, and maybe we can spot the issue. To post the SQL,
go into Query Design, then choose to View SQL - copy this statement and post
it.

--
Daryl S


"Basenji" wrote:

> Using Access 2003 a form has been created with a combo box to select the name
> of a practice. The criteria row in the query shows the form information. When
> the command button in the form is clicked to run the report the report runs
> with the labels appearing from the underlying query but does not show any of
> the detail information. What am I missing in the setup of the form or
> elsewhere?
From: ghetto_banjo on 30 Apr 2010 14:08
If you open the report while the form is closed, and you manually type
in the criteria, does the report show the data correctly?

You might want to post the SQL of the record source of the report.
 | 
Pages: 1
Prev: Parsing a string problem
Next: Tables: Appending Data, Link or Not to Link, That's My Question...