I am trying to expand on your example and have hit a stumbling block.  I
was able to duplicate the example fgut gave and have it execute a query.
 I want it to execute a report instead. The report executes the query
so the criteria for the query should be the same. The only change I was
expecting to do was instead of DoCmd.OpenQuery was use DoCmd.OpenReport.
 That works but the issue I ran into is the actual query.  The data
field that I have allows for entry of multiple cancer types.  They may
not be in the same sequence or count so I use" like "*" & [Enter cancer
type] & "*".  While this works like I charm, I would prefer the combo
box to give the types.  Removes the misspelling issue.  I tried: like
Like "*" & [forms!FindCancer!FindCancer] & "*".  I select the type, the
report executes but the result is a blank report.  If I remove [] and
use "" I get everything in the table instead of the desired type.  If I
remove Like "*" & components, it generates a blank report. What am I
missing.

Thanks,

Guy