Is your form "bound" to a query or a table?
If it is, and if it is the correct query/table, my next step, if this were
mine, would be to start over building a new form from scratch.
Or maybe one of the other newsgroup readers can offer a different
perspective...
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"julief" <julief@[EMAIL PROTECTED]
> wrote in message
news:F3DDE346-0CB4-43AC-B1ED-86212FB412B6@[EMAIL PROTECTED]
>I can see the control, if I pick it up I still get the #Name error, if i
>try
> to pick something else up I get the #Error message.
>
> "Jeff Boyce" wrote:
>
>> I've only run across that when Access can't figure out what you're
>> telling
>> it to use. Can you open that form in design view, open the properties
>> window for that control, and pick the correct field from the listed
>> fields?
>> And if that doesn't work, what happens if you pick one of the other
>> fields
>> (incorrect, I know, but if you can see it displayed in the form, that
>> tells
>> us something...)
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "julief" <julief@[EMAIL PROTECTED]
> wrote in message
>> news:B8E5C095-ADF9-4590-AABD-949A31783D6A@[EMAIL PROTECTED]
>> >I have tried your suggestion and it still produces the same result. I
>> >have
>> > checked all the spellings and they are correct.
>> >
>> > "julief" wrote:
>> >
>> >> I am trying to put a total from a sub form onto another form but
keep
>> >> getting
>> >> the #name error message, any pointers would be most welcolm.
>> >>
>> >> I have a form named test table based on query, fields quantity, unit
>> >> cost
>> >> and total. In the footer of the form i have added text box which is
>> >> named
>> >> total unit cost. In the control source =sum([total]). This
produces
>> >> me
>> >> with
>> >> the correct results.
>> >>
>> >> I have created another form named link form which I have added a
text
>> >> box
>> >> and input against the control source =([test table].Form.[total unit
>> >> cost].
>> >> The only result I get is the #name when in form view.
>> >>
>> >> I have set these forms, tables up as a test, as I am experiencing
the
>> >> same
>> >> problem on another database and hoped I could get it working on
>> >> something
>> >> as
>> >> straight forward as this simple database. I am quite new to access,
I
>> >> have
>> >> had this working on another database and cannot see what the
>> >> difference
>> >> is to
>> >> idenftify where I am going wrong.
>>
>>
>>
|
