Order of events for select case

[sonny]

I re-arranged things in the code to try to make it clear as to whats going on. But I'm at a loss to why the qry will only run once. When I open the db and add a new record it works, when I try to add the next one, it doesnt....

Is this an issue with Access or is it me? I stripped it down in case someone could look at it....

The a mousehook module in the db to prevent scrolling..

 

[sonny]

I now have the form bound to the tbl but when I add a record on go to the edit record form the cbo to navigate has the new record in it but the form does not have it, unless I close the form and reopen it. Some how the tbl the edit subform is bound to, wont refresh....

The form is hidden until the user clicks on the option group but I cant seem to get the subform to have the latest data...

As far as the zips go, there can be different cities for a zip....