I have a form that uses a combo box to select a name. Various other information is obtained with the form. The problem that I'm having has to do with the fact that there are usually two repetittions of the form for the same person. I'd like for the user to be able to leave the previously selected name on the form and just tab past it to add the additional data. When the program was in Access 2003, in the form_insert event, I performed a requery of the form and this seem to work. But, under 2007, this will not work and the user is having to select the same name again in order for the combo box to react properly.
I've tried a requery on the control when it gets focus when the user tabs though the box, but this doesn't seem to work either.
Can someone suggest a work around to this problem?
So far the only thing that works is to re-select the name.