On Tue, 16 Oct 2007 15:13:03 -0700, Imarko
wrote:
>after I create this table I put it behind the field on lost focus or
>somethig elase
A table is not a field!
No, you would either include the table in the Query upon which your form is
based, using the suggested "non equi join"; or use DLookUp in the control
source of a textbox on the form. Again... *NO CODE* is needed *at all*. You're
not calculating this value, you're finding it in a Table!
John W. Vinson [MVP]