Refresh form data after adding new record

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

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

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
 
Emilia,

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

Kirstie
 
Back
Top