Traffic light form

[julief]

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 relationships 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.

 

[Klatuu]

If by [fieldname], you mean the name of the control on the form, that is all
you need:
=controlname

 

[Bob Quintal]

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 relationships 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.