Refresh one form from event on another?

D

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
 
M

Marshall Barton

Dean said:
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.
Click to expand...


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

Forms!sheetform.Requery
 
Top