See new record in puCombo Box

[gg]

I have a form, "Users" sourced to a User table. I have another
form,"OwnsBoats", sourced to another table. Within this other form, I have
a combo box that is Row Sourced to the user table and Control Sourced to a
field in the other form's underlying table.

When I enter a new user in the User form, then open the OwnsBoats form, the
combo box will not show the new user. I have tried OnUpdate docmd.runcmd
accmdsave and I have had the code close the user form before opening the
other form. The new user is definitely in the user table, but still doesn't
show in the combo box. If I close the OwnsBoatss form and reopen, it will
show. Is this normal or is it a bug?
I am using A2007 wit W7.

 

[Arvin Meyer [MVP]]

Are you trying to do this in a continuous form? It won't work that way.

 

[gg]

Yes, both forms are continuous . I changed code that the command to open
the 2nd form actually performs an open-close-open action and works. Clumsy,
but so fast that user won't see anything annoying. Thanks for
direction-much appreciated.