Printable View
I know how the DateAdd function itself works, but I just not sure how to work it in in Visual Basic. Here's the situation: I have a database in Access that contains a field called DateHired that is entered in using a form in Visual Basic. I also have a field called 3MonReview that I need to calculate using the DateAdd function. Where and how can I work the DateAdd function it to make this work?
I would place the code to calculate the 3MonReview date (using the DateAdd function) in the lost_focus event of the
DateHired control.
The other option is to place the code in the DateHired Change event and on confirmation that a valid date has been entered fire the code that will perform the date calculation.
I could be wrong but I think there is a function called ISDate() or someting like that.