Runtime Error 2465. What is it, and how do I fix it?

**Lou_Reed** · 06-14-2017, 11:38 AM

In the attached db with several screenshots, I have a form, frmEmail, that allows me to select an employee from a combo box as shown in one of the screenshots.

The employee name is selected and after that I get a runtime error of 2465. I am not sure what a runtime error 2465 is.

The additional 2 screenshots, show the combo box that is in the code where it crashes and the output of runtime error 2465.

It is here that things begin to fall apart.

I built the procedure from what I found on the net. It worked, but then I found that I must add some code in the after update section of the combo box. I am not even sure what this code
is there for. It must be added. The combo operation worked fine before the code was added, now it crashes with a runtime 2465 error.

How do I fix this?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

**pbaldy** · 06-14-2017, 11:42 AM

No attachment Lou.

**RuralGuy** · 06-14-2017, 11:52 AM

A description for the error.

2465

2007
Microsoft Office Access can't find the field '|' referred to in your expression.@You
may have misspelled the field name, or the field may have been renamed or
deleted.@@1@1@11730@1
2003
Microsoft Office Access can't find the field '|' referred to in your expression.@You
may have misspelled the field name, or the field may have been renamed or
deleted.@@1@411730@1

2002

Microsoft Access can't find the field '|' referred to in your expression.@You may

have misspelled the field name, or the field may have been renamed or

deleted.@@1@411730@1

**Lou_Reed** · 06-14-2017, 12:17 PM

Here are the attachments that did not make it in my initial post.

A zipped copy of my db is also included.

Sorry about that. All I can say is that I should be more careful.

Anyway the attachments are there and they should have been in the
initial post.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

**pbaldy** · 06-14-2017, 12:35 PM

What is it you expect to happen? As the error says, there is no control named "Position" for it to set focus to.

**Lou_Reed** · 06-14-2017, 12:57 PM

Let consider what I expected to happened. Anything, but a runtime error crash. I got this code in the after working on parameter query and noticed that it was to be put in after update on the combo box event tab.
Consider:

[

Code:

 DoCmd.ShowAllRecords
     Me!Position.SetFocus
     DoCmd.FindRecord Me!cboEmployeeName

The middle line does have a position. So it got what it wanted?

Is there something wrong with the line : Me!Position.SetFocus

I am just am quite new to this. It seem that all that was needed is in the line in question.

As I said in the initial post what is this after update code for?
If I knew that it would probably help in understanding what is going on.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

**pbaldy** · 06-14-2017, 02:27 PM

Well, if you want something other than a crash, use a control that exists. There's nothing wrong with the line itself; it's trying to set focus to a named control. That control has to exist though. It doesn't, so you get an error.

I'm curious, if you don't know what it's for, why did you include it? The goal of it is to move the form to the selected record. "Position" would be the name of the control you wanted to use for the search. In your code, it would search that field for the name in the combo.

**Lou_Reed** · 06-15-2017, 12:51 PM

I have learned to take some code that exists and works and modify it for my situation. It just seems the easy way. Now I saw this online and on YouTube. It works and it meets my needs, so I paid the most sincerest and highest complement I could; I stole it.

However, I do not understand it crashing on that line.It must have been left out in the explanation. So I was baffled as to why it crashed.

Please answer two thins. Why is this code there in the after update section (IE. what does it do)? Secondly how do I fix it it?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

**pbaldy** · 06-15-2017, 04:09 PM

I've answered both:

The goal of it is to move the form to the selected record. "Position" would be the name of the control you wanted to use for the search. In your code, it would search that field for the name in the combo.

That control has to exist though. It doesn't, so you get an error.

I don't know how to say this any clearer. It errors because it refers to a control (textbox, etc) that doesn't exist on your form. The code can't set focus to someplace that doesn't exist.