Group: microsoft.public.access
From: John W. Vinson
Date: Tuesday, October 16, 2007 5:58 PM
Subject: Re: need help in with code

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]

Safety Articles | News in English | 20lbs in 30 days | Bluegrass | Usenet Newsfeeds