fresh only combo boxes on forms that are stayed open?
Posted on 2012-03-16
I have a acess 2007 database and several forms/subforms with combo boxes.
As example, I have three forms called publication, author and institution.
My users usually open all three forms to do the data entry.
The publication has a combo of authorlist.
When I don't see the author name, I go to the author form and create a new record.
After adding a new author, I ask users to click the refresh all button so the author combo box on the publication will requery it.
This refresh all makes all the opened forms to requery and lose the location of currently working location of the record.
What would be a fix for this kind of situation?
basically when I enter a new cord, I want only requery any controls that uses that table.
So I don't have to use refresh all button.
Do I look for specific combo boxes that use the table to which a newly added record went from _AfterUpdate()?