nothing like posting to one's self is there... a tidier way might be like the
following:

since the F9 key is does the 'update field' task, you can simply go ctrl-A,
followed by F9.

No need for a macro... anything better?

"GenesisBlade" wrote:

further to my question, i have found a temporary messy solution... i could do
with a better one, if someone knows, however.

having already added the 'update field' icon to my menu, i select 'record a
macro', select all (ctrl-A), and press the 'update field' icon. End macro.

so i have a new maco... but is there a better, prettier way?

"GenesisBlade" wrote:

I have created a form, with numerous fields that are set to autopopulate a
grid at the end. The functionality works, but I need the form to update as it
goes, rather than only be triggered when i print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars at the
top (customise menu) and then can select all (ctrl-A) and press the button
and hey presto... but that will be too technical for my users... can i set a
macro to a key, to activate the 'update fields' option? If so, how?!

Many thanks, in advance