I have a simple form that updates a table. I have a look up to another table inside the form that looks up city and state. So when my users type in the street address they tab to city pick from the drop down list and then that will fill in the state. Works great the first time but if they change the city it does not requery the state. Even if I hit enter on the city field.
I have tried on the form on got focus a me.refresh and me.requery and both times it errors out that me cannot find the object me.
It works if I do a Shift + F9. I have tired to put the me.requery on the event also in the field..