Link to home
Start Free TrialLog in
Avatar of rogerdjr
rogerdjrFlag for United States of America

asked on

Combo box to select file names

Looking for a way to have a combo box act like explorer searcing directories and when I identify a file to link to the record, click on it and it saves the link / file & path name
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Where is the combobox?

Sid
aikimark: Is the combo in Access?

Sid
But when I replied there was only "Microsoft Applications"?

Sid
Maybe OP added 'Access' Later?

Sid
Ah! How dumb of me? lolzzz

Yes I missed that. Thanks.

Sid
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The sample DB from this site should give you a good start:

http://www.lebans.com/callbackbrowser.htm
Avatar of rogerdjr

ASKER

Public Function SelectFile() As String

Works great - is there a way to "preset" the function so it starts at a selected path?

Thanks
Add a static string variable that contains the path.
Near the top of the routine check the length of the variable.  If = 0 then initialize it with a default path.