afterupdate error

[willmafingerdo]

Hello,
Just had a new error pop up on an "Afterupdate" event... when I update the 1032startDate field it is coded to add 15 months to the start date. I have posted pics of my code, the arrow points to the line it keeps telling me my error is at... was wondering if anyone could help point me in the right direction?





Thanks,
Will

[pbaldy]

What is the error description?

[CJ_London]

my guess would be it is either field names starting with a number or using the square brackets

[HiTechCoach]

Make sure the control names does not match the field names for anything used in your VBA code.

Example:
Control Name: txt1032FollowUpDate
Control Source: 1032FollowUpDate

This helps remove any ambiguity that can confuse Access.


TIP: Posting the code using the forum code tags is much better. The image makes it very difficult to modify your code. When I preview my post before submitting I can;t see the image anymore.


In the after update event it would be the following:

Me.txt1032FollowUpDate = DateAdd("m",15, Me.txt1032StartDate

This code is refencing the text box controls in a way that is not ambiguous to Access. Access won't have to guess.

[willmafingerdo]

Thanks everyone, I finally got a chance to get back to this.. I ended up deleting the fields off of the form and putting them back on and re-wrote the after update action and its working

[pbaldy]

Glad you got it fixed.