CREATING CALCULATED FLD TEXT RESULT

[Rich_Lovina]

Newcomer to VB thanks to the Forum. What Sub routine would I use to achieve the following (in my lay language):

In my Form, Fld 1 may be blank, Fld 2 may be blank and Fld 3 may be blank, but each or all may contain data.

However;

I want Fld 4 (a 'global category') to update in the following priority order:

If Fld 3 notblank, fill Fld 4 with data from Fld 3, butif 3 blank and 2 notblank fill 4 with data from 2, butif Fld 2 and 3 are both blank, but Fld 1 notblank, fill Fld 4 with Fld 1 data.

I assume, from limited VB knowledge this would go in as a Sub Routine?

 

[Rich_Lovina]

Thanks Pat. Not too complex at all!

 

[Rich_Lovina]

Okay, it's definitely is working, after I figured out how to Insert Procedure Public Function. Thanks, great!

It did one other funny thing though...it turned the tab option to 'NS' on one of the other fields from the table containing to Fld1. Ideleted that option and all's working.