Making a path to a folder

[Guest]

In a form I have used a button to create a folder in a particular location
on a server, naming the folder using two fields from each record as below

MyFolder = Me![txtRef] & "_" & Me[txtName]
MyPath = "\\Server\PPS\LossFiles"
MkDir MyPath & "\" & MyFolder

On the form after the folder as been created, I want to retain the location
of the folder so that I can access the folder from within the form. How can I
do this??

Thanks in advance

Matt

 

[Guest]

The easiest way is to create an unbound text control on your form and set its
Visible property to No. Store your path name in the control.

TomU