Hello!

I would like to know how to specify a field's contents in a command button.
I'm using Access 2000 here at work.

I have a field 'Program File Name' that I have the full path name to a file
stored.  I have assed a command button to open up the preferred editor for
these file types, and that command works just fine. Now I would like to open
the file specified in the above field. Note: each record has a unique file
specified in the field.

Below is the coding for the Event Procedure:

Private Sub c_OpenCodeFile_Click()
On Error GoTo Err_c_OpenCodeFile_Click

   Dim stAppName As String

   stAppName = "C:\mcamx\common\editors\mastercam\MCXStart.exe"
   Call Shell(stAppName, 1)

Exit_c_OpenCodeFile_Click:
   Exit Sub

Err_c_OpenCodeFile_Click:
   MsgBox Err.Description
   Resume Exit_c_OpenCodeFile_Click
   
End Sub

Thank you in advance for any help! I really appreciate it.
~Kathy