Access VBA questions!

[fjcunninghamjr]

Good morning and thanks for any suggestions!
Using VBA: How to use the control AUTO POLICIES.EFFECTIVE DATE to set 6 months ahead in
the control EXPIRATION DATE. Both use Short Date as the format type.

In the EXPIRATION DATE field I tried =[EFFECTIVE DATE]+182 but in some instances it jumps a day ahead or behind.
For example, if I input 01/25/2022 the result is 07/26/2023 instead of 07-25-2022
Using a command button to enter in date is my preferred end result. That way I’ll have a button for a


6-month policy and a 12-month policy

[CJ_London]

investigate the dateadd function e.g.

=dateadd("m",6,[EFFECTIVE DATE])

should be no need to store the value in a table, just calculate as required

https://learn.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/dateadd-function

[xps35]

Crossposted at https://answers.microsoft.com/en-us/...c-127c5460e683

[Micron]

fcunnjinghamjr - you might want to read this lest you quickly lose audience members.