• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • 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
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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