How do I insert an attachment using a form?

[mitcheljp]

I have an DB (2003) and I have a table with a column of type OLE Object.

I have a user form, and on this form I want to have a field where the user can attach documents (mainly word docs, but possibly excel, images).

How do I do this?

What type of control do I use to add this field on the form?



I have the form, and am working on the code to store the input to various tables.. but I'm not sure which control type I should use.

Basically it would be nice to have a button they click, and get a browse window to locate their file, then attach it.

Any suggestions would be much appreciated!!!

Thanks,
Mitch

[NTC]

the field you need in your underlying table is a Hyperlink field. then add that to the form.

once you have your form ready, practice linking to an outside doc - put your cursor in an empty field, right click and then follow the OpenHyperlink....you'll find that the way to set it up isn't exactly obvious or intuitive......but it works once you understand it. So I put a label next to it with written instructions.....

keep in mind that the path must be universal to all users - so be sure to stop at the top of the root. I have seen some PCs that people start using shortcuts and the whole path doesn't get into the db...and it works only from their PC and not from others....