Hi Katie,
Is TextBox2 bound to a field? If not, you can set the Control Source property of TextBox2 to:
=Textbox1 + 248
There is no code/vba required.
If TextBox2 is bound to a field, I would question the need to store a value that can be calculated.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 8 Feb 2016 09:09:25 -0800
Subject: [MS_AccessPros] Set the value of a textbox based on the value of another textbox
In Microsoft Access 2007, what VBA code do I use to set the value of a textbox based on the value of another textbox?
For example, if someone enters a date value of 2/8/2016 in Textbox1, then I want to set Textbox2 = Textbox1+248.
So that, for example, Textbox1 is 2/8/2016, and Textbox2 is 10/13/2016.
Any help is greatly appreciated.
Thanks,
Katie
Is TextBox2 bound to a field? If not, you can set the Control Source property of TextBox2 to:
=Textbox1 + 248
There is no code/vba required.
If TextBox2 is bound to a field, I would question the need to store a value that can be calculated.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 8 Feb 2016 09:09:25 -0800
Subject: [MS_AccessPros] Set the value of a textbox based on the value of another textbox
In Microsoft Access 2007, what VBA code do I use to set the value of a textbox based on the value of another textbox?
For example, if someone enters a date value of 2/8/2016 in Textbox1, then I want to set Textbox2 = Textbox1+248.
So that, for example, Textbox1 is 2/8/2016, and Textbox2 is 10/13/2016.
Any help is greatly appreciated.
Thanks,
Katie
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar