I want to write the contents of a field on a form to a text file when I hit the 'Save' button. This works O.K. the first time, but thereafter I get a "run Time error 70 - permission denied"! The code I am using is as follows, any suggestions?
Private Sub cmdSaveEntry_Click()
intFileNum = FreeFile
If Len(Me![txtField1].Text) = 0 Then
MsgBox "There is nothing to save!"
Open "c:\savetext.txt" For Append As #intFileNum
Write #intFileNum, Me![txtField1].Text