Hello all. I have a comma delimited file named poskip.csv. I would like to read this file and put the contents into a message box, but am not sure of the best way to do this. My file would look like the following:

1, 4, 7, 25

and I would like to create a message box that says "The following orders could not be processed at this time: PO 1, PO 4, PO 7, and PO 25." Do I import this file into a temporary table, and then loop through the records to come up with this, or is there an easy way to do this using only VBA?

Thanks for any help,
Kevin

Kevin,

I would read the Access help on the Split Function (to split the comma-delimited text into an array of values).

With this tool, you can split the comma-delimited data into an array of values. From there, you can assemble the string to be displayed in the textbox by looping through the array of values.

Hope this helps,

Dennis