I have a main form (frmFileMetdata) that uses a query (qryFileMetadata) as it's recordsource. This query is simply two tables with a foreign key that matches the tables together.
In my form, I have a button (that is supposed to open a file using the UNC path of that file (from one of the two tables from that query above). My form is a split form so that I can click on any line (which will have the file and image path) and the button ('Open File') should open that file up. The button will also populate the time started text box field from when the user clicks the button.. the code reads as below:
Now if I didn't have the text field, the button works perfectly.. it opens up the selected file. But with the text field there, I receive a run-time error 3326: "The Recordset is not updateable"
What are some potential reason why I could be receiving this error? My PK's are on both tables in my query, FK's are fine, they query itself works when I run it. Still not able to understand why the recordset is not updating. Any suggestions?
In my form, I have a button (that is supposed to open a file using the UNC path of that file (from one of the two tables from that query above). My form is a split form so that I can click on any line (which will have the file and image path) and the button ('Open File') should open that file up. The button will also populate the time started text box field from when the user clicks the button.. the code reads as below:
Code:
Private Sub btn_OpenImage()
Dim errorMSG, errorTITLE As String
If Dir(Forms!frmFileMetadata!txtUNCPath) = "" Then
WarningImageNotFoundMsg = "The File was not found. Please check this file exists in the location provided manually:" & Chr(13) & Chr(13)
WarningImageNotFoundMsg = WarningImageNotFoundMsg & Forms!frmFileMetadata!txtUNCPath
MsgBox WarningImageNotFoundMsg
Else
If IsNull(Forms!frmFileMetadata!datFileDateTimeStarted) Then
Forms!frmFileMetadata!datFileDateTimeStarted = Now()
Now if I didn't have the text field, the button works perfectly.. it opens up the selected file. But with the text field there, I receive a run-time error 3326: "The Recordset is not updateable"
What are some potential reason why I could be receiving this error? My PK's are on both tables in my query, FK's are fine, they query itself works when I run it. Still not able to understand why the recordset is not updating. Any suggestions?