By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Run-Time Error 2465 on Report

P: n/a
I have an Option GROUP which produces 6 different report between two
dates.

A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.

I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.

Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."

I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.

Any ideas on how I may attempt to fix this?

Thanks!

John

Aug 5 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
rkc
On Aug 5, 4:05 pm, zufie <john.marru...@illinois.govwrote:
I have an Option GROUP which produces 6 different report between two
dates.

A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.

I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.

Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."

I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.

Any ideas on how I may attempt to fix this?
Are you given the option to debug along with the error message?

What else did you delete? It does not make sense that deleting
option buttons from an option group would cause that error as long
as the option group itself still exists.

What's the recordsource of the report look like?



Aug 5 '08 #2

P: n/a
On Aug 5, 4:34*pm, rkc <r...@rkcny.comwrote:
On Aug 5, 4:05 pm, zufie <john.marru...@illinois.govwrote:


I have an Option GROUP which produces 6 different report between two
dates.
A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.
I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.
Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."
I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.
Any ideas on how I may attempt to fix this?

Are you given the option to debug along with the error message?

What else did you delete? It does not make sense that deleting
option buttons from an option group would cause that error as long
as the option group itself still exists.

What's the recordsource of the report look like?- Hide quoted text -

- Show quoted text -
Yes, I am given the option to debug along with the error message.

That's about it.

I think I fixed it by removing VBA statements that mention to the
Service Categories field such as
Me![Service Categories].Enabled = False AND Me![Service
Categories].Enabled = True

Thanks!

John
Aug 6 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.