How do you store multiple file locations in a text box

[ChuckColeman1812]

I've implemented on a form a Command Button that opens up a dialog box to allow the user to find a photo and once the photo is selected, it stores the location in a text box, (not the photo, just the location). I need to be able to allow multiple photo's to be store in the same text box. That was one of the benefits of using an Attachment data type but based on lots of comments, I steered away from that.




Any ideas?


Thank's in advance.

[RayMilhon]

Use a listbox or combobox instead.

[dreday]

You can always use a delimiter too like a semi colon between each file path. Then if you needed to retrieve the locations from the text box just read the string character by character up until you hit a semi colon (or whatever character you choose)

[ChuckColeman1812]

Thanks. I created a separate table and now when the user clicks on a button to add pictures, it opens a Pop-up form based on the separate table, (in Continuous mode), and multiple pictures/files can be added. I appreciate the feedback. Thanks!