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 - 04 Aug 2005 22:05 GMT
>I would like to trigger the refreshment of one form based on insertion of a
>record in another form.
[quoted text clipped - 3 lines]
>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

Signature
Marsh
MVP [MS Access]