Find and storing file name

[drewduncan]

Hi:

Can anyone help.

Does anyone know how I can allow the user to browse and select a file. This file name then has to be stored in a variable.

Any help appreciated.

 

[oharab]

There are 2 ways.
The first involves adding a control to a form and using that, the second is available at

http://www.mvps.org/access/api/api0001.htm

Personally I always use the second option.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------