Re: Traffic light form

=?Utf-8?B?anVsaWVm?= <julief@[EMAIL PROTECTED]
> wrote in
news:9A15BB4E-A39F-408A-8FBC-B14BE78D5ACE@[EMAIL PROTECTED]
 

> I am trying to put together a form which would act as a traffic
> light indicator.  I have created a cross tab query and based my
> form on that.  This shows no of jobs at red, green or amber stage
> based on the type of job it is (there can be three types of jobs).
>  The form is set as a continuous form.  This bit works great.
> 
> I now need to add the totals from several other forms onto the
> same form.  There are no relation****ps I simply want to populate
> the form with the result of another query .  The totals on the
> additional forms have been placed in the footer and shows the
> results correctly. 
> 
> I have created an unbound text box on the form and in the control
> source input =[Formname].Form.[fieldname]  I get the result of
> #name.  I have checked all the spellings and they are correct.
> 
> Can anyone please point me in the right direction.  If this can
> only be done by vba, then I know nothing of vba and would really
> appreciate some help. 

The other forms must be open. You may want to use a subform control 
to embed the whole other form into the Traffic Light form.

The other way is to use a Dsum() against the query that supplies the 
value you want.



-- 
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com
**