[nick.moult]

Hi All,
I'd recently put together a database for somebody in MS Access 2003. Part of the front end had a form with a button the user could click to open up a dialog box. I achieved this using code I've shown below....

Dim fDialog As Office.FileDialog
Dim pDialog As Office.FileDialog

Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
etc

It was all pretty easy for me to do and worked fine. I've now realised though, that it doesn't work on Access 2000 and earlier, and the only way to do it is through activex controls.

I've go no idea how to do it, and have looked around online, but just don't know where to start.

Can anyone help? All I really need to be able to do is select files on the user's computer via form based front end witha dialog box.

Cheers
Nick