Dynamic foldernames

[Bob500]

Hi,

I have this code to open a tiff from access, based on the primary key of the current record in focus:

filename= "c:\docs\tiffs\" & Me!primarykey & ".tiff"

How could I adapt this to locate the file in a folder named the same as the primark key.

ie.

filename= "c:\docs\tiffs\'primarykey'" & Me!primarykey & ".tiff"

Thanks!

 

[Bob500]

No worries I got it....

tiffName = "c:\access\ipcis\" & Me!ipcisID & "\" & Me!ipcisID & ".doc"