Senin, 08 Februari 2016

RE: [MS_AccessPros] Set the value of a textbox based on the value of another textbox

 

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


__._,_.___

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:

Poskan Komentar