How do I append a form text field with values from a form list box?

[Sumnor]

I am using a form to define criteria for a report. It works beautifully when selecting one (1) value, but I want to select more than one value.

I thought that I could create a list box (named 'Status_Choices') that houses all of the choices for my end-user (Low, Medium, High, Closed). The user could select one or more choices and those choices would append to a text box (called 'Status') on that form. I would then point the report criteria to the Status field so that the report used all of the choices in that field as the criteria.

I've been trying to figure out how to do this for a while, but am stuck. Any help is greatly appreciated.

 

[PHV]

You have to build the WhereCondition parameter of the DocCmd.OpenReport on the fly, browsing the ItemsSelect collection of the ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244