Have to click twice to get AfterUpdate to work.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have form (MainForm) that contains a combo box and several bound subforms
that are child forms to the MainForm. MainForm is a bound form. Depending
on the selection made in the combo box on MainForm, the AfterUpdate event
will execute an SQL Insert statement that adds rows to a table and then
displays those rows on a subform within this MainForm.

The problem is that sometimes when I make the selection is my combo box on
MainForm, the subform does not reflect the new rows right away but if I
reselect the same value, the subform does show the new rows. It's almost
as if the rows in the subform are not availabe for selection right away. Has
anyone encountered this? Is there a way to ensure that the new rows are
shown right away? Thanks,
Debbie
 
Back
Top