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.
