I have a form which includes names, addresses and other details. I have a button which runs a macro which produces a letter and inserts the date on the form. My problem is that when I enter a new record and click the button I get errors. It's OK if I move away from and back to the new record or when I hit refresh before I click my button. Is there a way to include refresh in the macro (cant see it in the actions list) or is there another way to do this?

Any help would be appreciated.

Can you specify what error you are getting

Sure. I should have done that first - frustration getting the better of me!

The report (letter) is generated with #Error where the name and address details should be (these are text boxes with additional text concatenated) and other details missing (these are straight text boxes). The second action of the macro, which sets a value works OK.

Hope I'm telling you what you need to know!

It's easy when you know how! After a good nights sleep and with a clear head I found the RunCommand action with Refresh as its argument. Problem solved.