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

  • Thread starter Thread starter Larry Kahm
  • Start date Start date
L

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
 
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.
 
Back
Top