Error 2465 can not find the field ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Merg to the max - 11 Dec 2005 03:52 GMT

I have a report with a query data source. I can place all the fields on the
report and they print just fine. What I want to do is use 10 of the fields
in a calculation in code in the "detail on print" section. I don't what the
10 fields to print just the calculated string. When I try to use the fields
in code I get a "runtime error 2465 can not find ...

I have test ed with all sorts of ways to get at the fields

Me![Fields1] and [Field1].value and lots of others.

Reply to this Message

Duane Hookom - 11 Dec 2005 08:20 GMT

Use the fields as control source of controls. You can set their Visible
property to No.

Signature

Duane Hookom
MS Access MVP
--

>I have a report with a query data source. I can place all the fields on
>the
[quoted text clipped - 9 lines]
>
> Me![Fields1] and [Field1].value and lots of others.

Reply to this Message

Merg to the max - 11 Dec 2005 16:04 GMT

This does work but requires that I pile the hidden fields up the section I am
using. Sure seems like there must be a way to access the data source query
fields. Thanks for the suggestion, I will use it if I have to.

> Use the fields as control source of controls. You can set their Visible
> property to No.
[quoted text clipped - 12 lines]
> >
> > Me![Fields1] and [Field1].value and lots of others.

Reply to this Message

Duane Hookom - 12 Dec 2005 01:39 GMT

I am not aware of another method.

Signature

Duane Hookom
MS Access MVP
--

> This does work but requires that I pile the hidden fields up the section I
> am
[quoted text clipped - 19 lines]
>> >
>> > Me![Fields1] and [Field1].value and lots of others.

Reply to this Message