Refresh one form from event on another?

[Dean Slindee]

I would like to trigger the refreshment of one form based on insertion of a
record in another form.

Both forms have the same table as the datasource. The first form is a data
entry form (with text boxes), the second form is a datasheet view of all
rows in the same table. I would like to refresh the datasheet form when a
new record is added on the data entry form.



Can this be done, and how, which event?



Thanks,

Dean Slindee

 

[Marshall Barton]

I would like to trigger the refreshment of one form based on insertion of a
record in another form.

Both forms have the same table as the datasource. The first form is a data
entry form (with text boxes), the second form is a datasheet view of all
rows in the same table. I would like to refresh the datasheet form when a
new record is added on the data entry form.

Use the first form's AfterUpdate event to requery the second
form.

Forms!sheetform.Requery