Refresh form data after adding new record

[Kirstie Adam]

All,

Can anyone give me the code for refreshing a forms data after a new record
has been added?
At the moment it has been set up as a refresh button the user clicks, but i
would like it to be automatic.

TIA,

Kirstie

 

[Emilia Maxim]

All,

Can anyone give me the code for refreshing a forms data after a new record
has been added?
At the moment it has been set up as a refresh button the user clicks, but i
would like it to be automatic.

Kirstie,

the actual code is:

Me.Requery

if the code resides in the form's module (otherwise it's
Forms("MyForm").Requery

As to where to do it, depends where and how the new record is added.
Is it in code (if yes, please post)?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de

 

[Kirstie Adam]

Emilia,

The new record is added by hitting a button on the form which was created by
the form wizard.

Kirstie