How can I build/use a control to allow searching for a file somewhere on windows and then storing the full file name in a field on a form. Essentially it would be like invoking the "File - Save" dialogue box in any MS Office app, and then saving the selected file, with full path name, in a field on the Access form.

Here's the code to do it:
http://www.mvps.org/access/api/api0001.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access tools for developers - http://www.peterssoftware.com