State abbreviation MI fails in query

[Bob]

I have a query that links 2 tables, 1 is employee and the other is training
by their employee id. I have an input created in a query that allows you to
put in the abbreviation for the state to see just the records for that state.
When I put in MI I get the error No current record. Anything else I put in
returns that state or empty query if I put something bizare in there. So
when I do MN or MS it is fine. What is so special about the MI combination.
I can do MIS and get nothing back, but do not get that error.

 

[Duane Hookom]

I would check your autocorrect options. MI might be automatically spell
corrected to something else.

Either that or it's due to the poor performance of the Lions, season after
season ;-)

 

[Bob]

That did nothing. And in answer to your other question yes, I have verified
there is data that meets the criteria. Even if there was no data it should
bring up a blank form.

 

[Duane Hookom]

Do you have a corrupt record or something unique in a record with MI as the
abbreviation?

 

[Bob]

It does not appear so. Your question did motivate me to create another query
that does the same thing and it is working, so I have to wonder if there is
something in the existing query that is corrupt. Weird, but resolved for now.

Thanks for the help Duane