Error when closing form MCAUPdate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I receive the "You can't save this record at this time..." error when closing
a form. I've narrowed the problem to one of two lines of code (I've added
the ' so my form works otherwise.)
Private Sub Form_AfterUpdate()
'[MCAUpdateBy] = Environ$("USERNAME")
'[MCAUpdateDate] = Now()
End Sub

I have read about this in other postings and been through Allan Browne's
bug-3 process. I am still getting the error. Is there anything I am
overlooking? It is worth noting that the [MCAUpdateBy] and [MCAUpdateDate]
text boxes are located within the details section of the form. I also have a
Tab Control (TabCtl24) within the details section. This Tab Control holds
all the data input fields. It is also worth mentioning that when I look at
the underlying table, the data from these two inputs is not being recorded
but all other data entry or updates are recorded. Finaly, the behaivor of
these two text boxes and labels is odd - they will not stay "behind" or
"under" the Tab Control box.

Help is appreciated.
 
I added more info at the bottom.

John said:
I receive the "You can't save this record at this time..." error when closing
a form. I've narrowed the problem to one of two lines of code (I've added
the ' since so my form works otherwise.)
Private Sub Form_AfterUpdate()
'[MCAUpdateBy] = Environ$("USERNAME")
'[MCAUpdateDate] = Now()
End Sub

I have read about this in other postings and been through Allan Browne's
bug-3 process. I am still getting the error. Is there anything I am
overlooking? It is worth noting that the [MCAUpdateBy] and [MCAUpdateDate]
text boxes are located within the details section of the form. I also have a
Tab Control (TabCtl24) within the details section. This Tab Control holds
all the data input fields. It is also worth mentioning that when I look at
the underlying table, the data from these two inputs is not being recorded
but all other data entry or updates are recorded. Finaly, the behaivor of
these two text boxes and labels is odd - they will not stay "behind" or
"under" the Tab Control box.
Click to expand...

The first time the code runs, it results in the following error message:
Run-time error '2465'
Microsoft Office Access can't find the field '|' referred to in your
expression.

Upon hitting [DEBUG] I go to the script editor and the lines above are
highlighted.

I've triple checked my field names and they match the expression.
 
Back
Top