Value list appears in report

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

Guest

Hello

I am a new Access user & have a small problem

After generating a report, the values that I have for a field in my table as a pull down menu, all appear in my report. I would obviously like to have only the value I chose from the list to appear in the report. I'm sure this is not a complicated problem, but I can't seem to get around it. Thank you for helping a newbie...
 
The query on which the REPORT is based should refer back to the combobox on
the FORM for the selection criteria:

On the criteria line: Like MyForm!MyCombo

The above assumes that the value you want is in the bound column of the
combobox. If not you may have to use:

Like MyForm!MyCombo.column(n)

You can try the criteria lines above and run them from the QBE Wizard
without having to get out of the Wizard and try the Report until you get it
right. When you get the correct results, save the changes but don't save
the query as a named query, just keep it inside the report.

HTH
--
-Larry-
--

GA said:
Hello,

I am a new Access user & have a small problem.

After generating a report, the values that I have for a field in my table
Click to expand...
as a pull down menu, all appear in my report. I would obviously like to have
only the value I chose from the list to appear in the report. I'm sure this
is not a complicated problem, but I can't seem to get around it. Thank you
for helping a newbie...
 
Back
Top