Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Forms : Give a textfield the value of the concatenation of 2 previous fields

Hi,

I'm new in programming forms in Access ( via VB or wizards).

On a form I have created a textfield A and a date field B.
I have another field C.  C is empty when opening the form and should have the value of the contatenation of A+B on exit of field B.  ( C is gonna be used as unique key).
How do I do that. I tried with C Default Value = [A]+[B].
But alas.


Somebody ideas.   Also can you please recommand we some tutorials on programming in Access  (VB and wizards) who are on the web?
0
ruddi
Asked:
ruddi
1 Solution
 
Ryan ChongCommented:
Hi ruddi,

In Form_Current Event, try:

A.Value = B.Value + C.Value
0
 
kirthirCommented:
In the killfocus event of B, add the following code

C.value = A.value+B.value
0
 
bruintjeCommented:
for the second part of the Q you could check

http://www.microsoft.com/OfficeDev/Articles/OPG/
0
 
kirthirCommented:
For the second part of the Question, you can check the following site
 
http://www.mvps.org/access/

0
 
ruddiAuthor Commented:
I hope the other ones are not angry at me because I give the points to kirthir. The tutorial he linked me to is just what I search however  (and free).
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now