My Assistant
![]() ![]() |
|
|
Feb 28 2012, 08:20 AM
Post
#1
|
|
|
UtterAccess Member Posts: 21 |
I have a text box named "Audit_Schedule". What I want to do is have the the text box automatically update without user input. The data I want in the text box is the current calendar year and Audit Plan.
Therefore, for calendar year 2012 I want the text box to default to 2012 Audit Plan. In calendar year 2013, I want the text box to default to 2013 Audit Plan. Is this possible in a web database?? Thank you for any assistance. |
|
|
|
Feb 28 2012, 08:32 AM
Post
#2
|
|
|
UtterAccess Addict Posts: 274 |
Do this with tempvars. When you open the form run a macro that sets the values of a tempvar to some control values or calculation. Then setproperty value of the text box to that tempvar.
Bonnie |
|
|
|
Feb 28 2012, 01:29 PM
Post
#3
|
|
|
UtterAccess Member Posts: 21 |
Thx for the reply. I'll give it a try...
|
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 04:33 AM |