Access Tips: Watch out for case senstitive situations

I just spent like 2 hours trying to get a query with like 3 levels of sub-queries that I built in a sandbox with copied tables in Microsoft Access to work under a live ODBC linked connection with an Oracle database.

Guess what broke my query?

3 references to a user input form that were missing once capitalized letter.