Date plus three

[TomJamieson]

Hi,

I have a date field called bookedindate, another field called supplier, and another called bookedoutdate. What I want to happen is, if a certain supplier is chosen, the bookedoutdate automatically changes to 3 days after the bookedindate. I'm okay with most of the code, it's just how to do the actual date plus three part.

If supplier = "x" then

bookedoutdate = bookedindate +3. <-----it's this line of code I'm struggling with.

Thanks in advance.

 

[Brianwarnock]

Lookup DateAdd in VBA help

Brian

 

[TomJamieson]

Nice and easy, Thanks!