State abbreviation MI fails in query

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
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 ;-)
 
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.
 
Do you have a corrupt record or something unique in a record with MI as the
abbreviation?
 
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
 
Back
Top