Reports

[Guest]

I have a form that has a field called "Item" among other fields. The form is
derived from a query. The Item field is composed of a 4 digit number
followed by a description. I also have a report based on the form's query.
The report has a parameter requesting what "Item" number do I want the report
to select. I would like to be able to only type in the Item number and not
the full description to run the report. How can this be accomplished?
Thanks

 

[pietlinden]

I have a form that has a field called "Item" among other fields. The form is
derived from a query. The Item field is composed of a 4 digit number
followed by a description. I also have a report based on the form's query.
The report has a parameter requesting what "Item" number do I want the report
to select. I would like to be able to only type in the Item number and not
the full description to run the report. How can this be accomplished?
Thanks

if you have this value in a combobox, add a column to the combobox and
include both pieces. Then pass the two concatenated values in the
open event of the report. I'd scrap the parameter and just pass the
filter in the open event of the report.