Me.DueDate=fAddWorkdays(7,Me.PurchaseDate)
First, did you download the file from the link I posted?I entered the code
Me.DueDate=fAddWorkdays(7,Me.PurchaseDate)
In the AfterUpdate event of Purchase Date and its not working?
Yes, and make sure you leave the name as Module1 (or something similar). Also, please double check the syntax. I wasn't sure if the number comes first or later. Let us know how it goes.Yes I have it, please forgive my ignorance but I was not sure where to copy/paste the content. Would it be under Module?
Hi. Did you verify the syntax like I said? I don't have a copy of the file to verify for you. Can you maybe post the function declaration?Ok, I did as instructed and copied the material under Module 1.
I entered:
Me.DueDate=fAddWorkdays(7,Me.PurchaseDate) in the AfterUpdate event of Purchase Date.
When I entered 11/4/19 under Purchase Date, the Due Date says 10/20/2067.
Hi. I had it backwards. Try the new syntax I just posted above and let us know what happens.Is the function declaration the content in Module 1?
Hi. You're welcome. Good luck with your project.You Sir are a Master Mind!!!
Thank you very much!