I have a simple form with a command button.

The purpose of the command button is to import data from a text file AND repaint the active screen i.e. the form.

The import works successfully, but the RepaintObject macro action doesn't. When I close & open the form, then it's OK. For reasons that are too long winded, I can only use a macro rather VBA.

Can anyone tell me what I'm doing wrong.

There are no conditions in the macro.

You probably need to use Refresh or Requery rather than Repaint. Use help to determine which will satisfy your needs.

Thanks Pat. Requery did the job.