A
Antonio
I have a form that department members use to log
individual documents. We need to record when the
documents are sent and physically arrive in the
department. The specifics of each document is imported
into the database via floppy supplied by our Information
Systems department. I added a DateSent, SenderID,
DateRecvd, and ReceiverID field. The idea is that the
sending personnel (in a different department) log when
they send each document. Then, as the documents come into
our department, receiving person logs each document and
then prints a "did not receive" report at the end.
I tried to facilitate the process by putting code into
the "Double Click" event of the DateRecvd text box that
would automatically fill in the date as well as the
CurrentUser() in the ReceiverID field.
I typed the following code into the Double Click event:
Private Sub DateSent_DblClick(Cancel As Integer)
Me.DateRecvd.Value = Date
Me.ReceiverID = CurrentUser()
End Sub
I hit save and compile and it worked fine. When I re open
the form, and try to click on either of the text boxes,
I get an error message stating:
"Runtime Error '3326'"
"The Recordset is not updateable"
The debugger takes me to the Visual Basic Editor and
highlights the "Me.DateRecvd.Value = Date" line...but I
dont know what I am doing wrong...
I take it the code I wrote behind the double click is
incorrect...
I appreciate any help sent my way...
TIA
individual documents. We need to record when the
documents are sent and physically arrive in the
department. The specifics of each document is imported
into the database via floppy supplied by our Information
Systems department. I added a DateSent, SenderID,
DateRecvd, and ReceiverID field. The idea is that the
sending personnel (in a different department) log when
they send each document. Then, as the documents come into
our department, receiving person logs each document and
then prints a "did not receive" report at the end.
I tried to facilitate the process by putting code into
the "Double Click" event of the DateRecvd text box that
would automatically fill in the date as well as the
CurrentUser() in the ReceiverID field.
I typed the following code into the Double Click event:
Private Sub DateSent_DblClick(Cancel As Integer)
Me.DateRecvd.Value = Date
Me.ReceiverID = CurrentUser()
End Sub
I hit save and compile and it worked fine. When I re open
the form, and try to click on either of the text boxes,
I get an error message stating:
"Runtime Error '3326'"
"The Recordset is not updateable"
The debugger takes me to the Visual Basic Editor and
highlights the "Me.DateRecvd.Value = Date" line...but I
dont know what I am doing wrong...
I take it the code I wrote behind the double click is
incorrect...
I appreciate any help sent my way...
TIA