If you have your form protected for forms and have the field property
checked to calculate on exit, you don't need the F9 key. That is in the
online form, not the userform.

Signature
Charles Kenyon
Word New User FAQ & Web Directory: http://addbalance.com/word
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
> Great Forums for everthing Office but sometimes there is a lot of reading
> required when you want to do something that seems simple and to no avail!
[quoted text clipped - 68 lines]
>
> HeLp!
Bugs - 15 Feb 2006 22:56 GMT
Charles,
The fields that are being used to update are reference fields which are
based on values from Text Form Fields. These Text Form Fields have the
Fill-In Enable option checked so that the user can fill them in directly with
out using the user form.
The reference fields point to these fields but require for the user to
manually update them. It would be nice if I could come up with a macro that I
can add to my custom menu that will automatically update these type of fields
but that will be for later on as I need to complete the user form field
functionality.
I don't think I can protect the FA Document because it may cause other
problems with footers and headers that are currently being used but then
again I'm new to all of this so if you can detail a solution I can follow
through!
I appreciate your input regardless!

Signature
Thanks,
Bugs
> If you have your form protected for forms and have the field property
> checked to calculate on exit, you don't need the F9 key. That is in the
[quoted text clipped - 71 lines]
> >
> > HeLp!
Charles Kenyon - 15 Feb 2006 23:58 GMT
No!
If you are using a protected form and if the source fields are set to
calculate on exit, the REF fields based on the form fields will update.
http://gregmaxey.mvps.org/Repeating_Data.htm
If this is the sole purpose of your UserForm, you are reinventing the wheel.

Signature
Charles Kenyon
Word New User FAQ & Web Directory: http://addbalance.com/word
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
> Charles,
>
[quoted text clipped - 108 lines]
>> >
>> > HeLp!
Hi Bugs,
i'm no good at userforms,
but to me it seems that Initialize isn't the right event.
Try putting your code in UserForm_Activate()

Signature
Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
Bugs - 15 Feb 2006 22:47 GMT
This did the trick!
Thanks Helmut now I can clean up the user form and wrap up this part of the
custom menu finctionality.

Signature
Thanks,
Bugs
> Hi Bugs,
>
> i'm no good at userforms,
> but to me it seems that Initialize isn't the right event.
> Try putting your code in UserForm_Activate()