Have to click twice to get AfterUpdate to work.

[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

 

[Al Camp]

Debbie,
Use the AfterUpdate event of the combo to Requery the subform.

 

[Guest]

Al,
Thank you, I will try that. Take care,
Debbie