requery question

[ken]

Hi,
In my after_insert event on a form I add additional records to the
table. The problem I'm running into is that I need for those records to
show up after the after_insert event ends. If I requery the form during
but at the end of after_insert I don't see the recently added
records(using VBA the INSERT statement). However if I use a refresh
button(onclick me.requery) then I see the records. But I need to see
the records at the end of after_insert or slightly after...
any suggestions?

[ken]

Upon an insert of a record is there any event after the "after_insert"?
I've been looking but there does not seem to be one...

[the chiller]

well, obviously you must figure out a way to do the Me.Requery after
you've inserted the records.
In the afterupdate, just make sure the requery follows the record
adding code.
Or maybe you can do record adding in the beforeupdate event, then
requery on afterupdate.

[ken]

Me.requery does not work in after_insert nor in after_update. I believe
that's because the record that I'm inserting or updating has not been
saved? So I have to save the record(pass the after_update or
after_insert events) then I could requery, but I don't know how to do
that.

[John]

These events are explained in access help. Place the cursor on any of these
events on your form in design view and press F1

John
"ken" <ge****@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi,
In my after_insert event on a form I add additional records to the
table. The problem I'm running into is that I need for those records to
show up after the after_insert event ends. If I requery the form during
but at the end of after_insert I don't see the recently added
records(using VBA the INSERT statement). However if I use a refresh
button(onclick me.requery) then I see the records. But I need to see
the records at the end of after_insert or slightly after...
any suggestions?