Message pop up after field selection/entry and default value

[ktran4]

Hello,

I have a table with fields [Request Type], ]ShipDT], and [DueDT].

1. How do I have a pop up message to remind user input ECO# in the [ECONum] when the value ECO or I&O is selected for [Request Type]?

2. Can I set default value for[DueDT] 30 days from [ShipDT]? I entered =DateAdd("y",30,[ShipDT], but I have error that it does not recognize [ShipDT].

Your kind help is appreciated.

Ktran4

 

[Ranman256]

Y = years. You set it for 30 years. D is for days.
ShipDt=Dateadd("d",30,[startDate])

And you have to have a startDate to add the 30 days to.

If isnull(me.field) then MsgBox "you must enter date into field"

 

[ktran4]

Thanks for your help, Ranman!