Error 2465 can not find the field ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the fields as control source of controls. You can set their Visible
property to No.
 
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.

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

--
Duane Hookom
MS Access MVP
--

Merg to the max said:
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.
Click to expand...
Click to expand...
 
I am not aware of another method.

--
Duane Hookom
MS Access MVP
--

Merg to the max said:
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.

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

--
Duane Hookom
MS Access MVP
--

message
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top