TextBox [Date]+30

Pro

Registered User.
Local time
Today, 09:00
Joined
Apr 28, 2015
Messages
19
Hello All ..
Please Help ..

I have 2 bound TextBox ( Date & ValidityDay ) on form base on query and query base on table

I need ValidityDay TextBox get and display value from [Date] TextBox that I pick it +30Day and return this value to table and save it when I press save record button

Thanks...
 
Dear pbaldy
Thank you very much .... it ok

Private Sub Date_AfterUpdate()
Me.ValidityDay = Me.Date + 30
End Sub

........
 
No problem. If it isn't too late, I'd change the field name of "Date", which is a reserved word. Access can confuse it with the Date() function.
 

Users who are viewing this thread

Back
Top Bottom