Is it possible to amend the following code so that a default path, perhaps contained in a hidden text box, can be used each time the dialog is opened.
Here is what I have now: (please note I had to retype this manually, database on different PC, so it could contain a typo but you will get the gist of what it does)
Private sub cmdBrowse_Click
On Error goto err_cmdBrowse_Click
Dialog1.CancelError = true
Dialog1.flags = cdlOFNHideReadOnly
Dialog1.Filter = "Text Files (*.doc)|*.doc"
'set default file name
me.dialog1.dialogTitle = "Select word document to be linked"
me!text78 = me!dialog1.FileName
error handling lines follow etc
Lets say I have another text box, ie txtDefaultPath, which has "G:\docs\Jan2000" as it's contents. Can I have the dialog box automatically open to this folder when the browse button is clicked.
thanks for your help