Michael,
You can use a multi-select list box and a little code to modify the where condition of the DoCmd.OpenReport method.
A no code solution is to create a small table that allows the user to enter "one part or many parts". Join this little table to your table of parts and only those in the "small table" will render in the report.
Duane Hookom MVP
MS Access
----------------------------------------
> From: michaelb@raycomfg.com
>
> Hello everyone,
>
> I am writing a query for Access front end that ties into a MS SQL database backend. The query is based on a report originally written in Crystal Reports that allows users to locate all shop orders for a part (or parts) that the user specifies, with a given order status and one of several flow codes from our MRP system. I'm rewriting the report to accommodate a user request to display a bitmap of a drawing for each part the query returns (which would be displayed in a report derived from the query). That is why I'm trying to do this in Access. The status code and the flow codes searched under would never change. However, the user needs the ability to search for one part or many parts, and this is normally accomplished with a parameter in the Crystal Reports version that allows for multiple values to be entered. Everything I've know (or been able to find) on Access query parameters indicates only one value can be entered at a time in a query parameter. Is there a way allow multiple values to be entered for a single field in an Access query? I'll admit my coding knowledge is rather limited, but I'll try anything if the solution requires VB coding (or other).
>
> Thanks in advance,
>
> Michael
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar