retrieve data back to userform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi,

I have a problem with bookmarks. I have a userform called "New application
form" made up for a template .dot. In the word, i have insert bookmarks that
correspond to the text fields in the userform. So, when user finishes filling
out the fields and hit "OK" button, all the data are put into bookmarks.

However, what i'm trying to do now is to be able to retrieve all those data
back from bookmarks to the form. I know the code to retrieve values from
bookmarks to textfields in the userform. The reason for this is to allow user
to edit some of the data through the form. (don't know if by doing this, i
have made my life more difficult). Anyway, i created another userform called
"Editing application form" and a Edit button (use macro). So when user clicks
on this button, it brings up the "Editing application form" with all the data
in their appropriate text fields.

The problem here is When user hits "Edit now" button, i got error message
saying
"The requested member of the collection doesn't exist". When i checked the
bookmarks, those bookmarks are not there. I believe this is because they are
not entered in the first place during the creation of the new application
form. (something new i learn again today)

so is there any other ways that i could use apart from bookmarks and still
helps resolve my issue?

Thank you in advance


.



Relevant Pages

  • Re: UserForm interaction
    ... (I found out today that bookmarks can be fragile. ... can a user dynamically update the UserForm that is being ... Dim oCtrs As Controls ... For Each oBm In ActiveDocument.Bookmarks ...
    (microsoft.public.word.vba.beginners)
  • Re: retrieve data back to userform
    ... are very clear to me but i don't understand why the {DOCVARIABLE test} did ... Anyway, in the userform, i have a textbox called txtvarname and a button ... I have a problem with bookmarks. ... "Editing application form" and a Edit button. ...
    (microsoft.public.word.vba.general)
  • Re: VBA User Forms
    ... End Sub lines for this by choosing UserForm in the left-hand dropdown at the ... In addition to the AutoNew or Document_New macro that shows the UserForm ... They're much more robust than bookmarks, since users have no access to them. ...
    (microsoft.public.word.docmanagement)
  • Re: UserForm interaction
    ... As bookmarks are rather fragile in the hands of users, ... Dim oCtrs As Controls ... For Each oBm In ActiveDocument.Bookmarks ... the document back to the UserForm. ...
    (microsoft.public.word.vba.beginners)
  • Re: UserForm interaction
    ... A whole page probably implies multiple paragraphs and while you ... userform that is being filled out. ... recommend using document variables also for larger pieces of text (entire ... (I found out today that bookmarks can be fragile. ...
    (microsoft.public.word.vba.beginners)