command button specific to form record

[Dave_epic]

Hi

I have a form where I have added a command button which opens a saved notepad file when you click it. However the command button performs the same action whichever record of the form you are on. What I want is a command button specific to only one record of a form, not the same across every record. How is this possible

Thanks

 

[pbaldy]

Is it supposed to open a different file? If so, how would it be named? What is your code now?

 

[Dave_epic]

Hi

yes its supposed to open a different file on each record.

the code at the moment is

Private Sub view_Click()

Call Shell("NOTEPAD.EXE c\:test\0903IDC.txt", 1)
End Sub

thanks

 

[pbaldy]

You could try something along the lines of:

Call Shell("NOTEPAD.EXE c\:test\" & Me.Whatever & ".txt", 1)

You may need to build the string first, if it doesn't work within the Shell function.