There are a number of problems here.
1. Your field name is too long. Field names are limited to 64 characters.
2. You have a ' in the field name. Not good
3. It may very well be a typo:
day's most stressful event that yuo reported
Maybe you mean you instead of yuo
Your approach of making your field names a survey question is not a good
idea. I better approack would be to have a questions table with the question
as a field in that table. I think a remember a post where you were advised
against this approach recently. Now maybe you can see why it has been
recommended you don't do this.
Miguel Vivar said:
Klatuu:
Here is my posting:
Private Sub
Did_any_significant_negative_experience_occur_last_night__after_AfterUpdate()
Dim YesAnswer As Boolean
YesAnswer = MsgBox("Did any significant negative experiences occur last
night (after you completed yesterday's survey)?", vbYesNo) = vbYes
Me.[Forms]![Daily table 2]![How stressful was this experience in comparison
to the day's most stressful event that yuo reported in yesterday's survey] =
Yes
End Sub
Klatuu said:
It means you are referring to a field that does not exist. Post your code so
we can see if there is anything obvious.
:
I'm creating a question to appear right after a "yes/no" question is
answered, and I got the error message 2465 in VBA. What does it mean?
