If by [fieldname], you mean the name of the control on the form, that is
all
you need:
=controlname
--
Dave Hargis, Microsoft Access MVP
"julief" wrote:
> 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.
|
