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?
ruddiAsked:
Who is Participating?
 
kirthirCommented:
For the second part of the Question, you can check the following site
 
http://www.mvps.org/access/

0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.