Refreshing Data on Form

[firework]

Hi,

I have not used MSAccess for sometime (not a expert to begin with). I know I used to be able to do quite a few thing but I don't seems to be able to use the same syntax for same operations.

I have various records display on a form when a record is added or deleted, I want the form be refresh so that user know what they are seeing is what is in the system. I have tried the following but non work.

I used to be able to do it two ways.
1. using Forms!FormName.requery
or
2. create a command button, using the wizard to refresh form.

However I don't seems to be able to use above at all. I am on MSAccess 2003 on Window xp sp2.

The

 

[RuralGuy]

Have you already applied SP3 for Office 2003? If so you may want to apply this HotFix.
Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
If you have not already applied SP3 then I would hold off 'til SP4.

 

[firework]

Hi there,

The refresh doesn't work the way I want it but I have used another way to do it. Instead of deleting the record, I logically mark it for deletion then the refresh work and on form exit, I deleted the logically marked record.

Many thanks