Need to populate a field if another is pupulated

[jsnunez]

Hi all

I have a regular bound form. And I have a field "result" that needs to be populated with the value entered in
- the concatenation of fields from the group1 (field1, field11, fiedl 12, field13, field14)
- or the concatenation of fields from the group2 ((field2, field21, fiedl22, field23, field24)

When I create a new record, or modify an existing one, if one of these group fields is modified I want to populate "result" with the rigth value.

How can I do that?

I what event do I need to add a code suche as:
result = field1 + field12 + field13 ...

thanks
jsn
thanks
jsn

 

[danvlas]

No code required.
Control source:
= Field1 & Field2 & Field3
It will update automatically.

Using '+' as operator will render the result Null if ANY of the fields is null, so you should use '&' in your case.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jsnunez]

I am doing the concatenation in the before_update event of the form and it works

thanks
jsn