Form with combo box to set criteria for query and report

[Basenji]

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?

 

[Daryl S]

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.

 

[ghetto_banjo]

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.