When to requery main (continuous) form after adding new record

[Larry Kahm]

I am using a continuous form, based on a query, that displays some Company
information.

I have a button on that form that allows someone to add a new Company record
by opening another (data entry) form.

When I close the data entry form, I would like the continuous form to
reflect the new record that's been added to the database.

I have had limited success in locating the most appropriate place to put the
requery of the continuous form. I believed it should be put in the data
entry form's OnClose event, but that has only been moderately successful.
In other words, sometimes it works and sometimes I have to hit Shift+F9.
(Never thought I'd want consistency in an Access application, but...)

What >is< the most appropriate place for the code?

Thanks!

Larry

 

[Jon Lewis]

AfterInsert

HTH

 

[Allen Browne]

My preference would be to use the AfterUpdate and AfterDelConfirm events of
the form where you enter the new value for the list.

Example in:
Adding values to lookup tables - Option 2: Pop up a form
at:
http://allenbrowne.com/ser-27.html#PopUpForm

 

[S.Clark]

I don't understand why it would be only 'moderately successful'.

Try the OnActivate of the continous form, but that will cause the cursor to
fly up to the first displayed record.