Using Access 97
I have the following Call to SHELL, which correctly opens the file
specified.

 Call SHELL("NOTEPAD.EXE  c:\sample1.txt", 1)

Now, is if it is possible, I would like to know the format for opening
the file if
the path is a variable, and  specified in the field of each record.
Say the field is called [FileToOpen], I'm after something like:

 Call SHELL("NOTEPAD.EXE & [FileToOpen]", 1)

but of course the above doesn't work since it looks for the literal
file name: '& [FileToOpen]' rather than the value in the field.

Thanks for any help
Van Cox

Call SHELL("Notepad.exe " & Variable & ".txt", 1)
or
Call SHELL("Notepad.exe " & Me!File,1)
(same thing really)
Or even this,

Dim StrShell as String
StrShell = "Notepad.exe " & Variable
Call Shell(StrShell,1)