Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data entry order in form (Office 2000)

    Hi Again,
    I want to change the order data entry in done in a form. I asked Clippit but he can't find it for me.
    Can someone help.
    tks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data entry order in form (Office 2000)

    You need some VBA code for this. See How to set the "tab order" of a Word form on the Word MVP site.

  3. #3
    New Lounger
    Join Date
    Jan 2009
    Location
    AUrora, Illinois, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data entry order in form (Office 2000)

    I have tried this method in a form that I created. It works for Text Form Fields, but I can not get the StrFFldToGoTo string to go to a Checkbox Form Field. Is there an extra line that needs to be added to the code? Do I need to have any specific references checked in the VBA editor?

    I wish you could just assign the Form Field tab order the same way you do in Access, but then that would just be too easy.


    Sub TabOrder()

    Dim StrCurFFld As String, StrFFldToGoTo As String

    'First get the name of the current formfield
    If Selection.FormFields.Count = 1 Then
    'No textbox but a check- or listbox
    StrCurFFld = Selection.FormFields(1).Name
    ElseIf Selection.FormFields.Count = 0 And Selection.Bookmarks.Count > 0 Then
    'Textbox
    StrCurFFld = Selection.Bookmarks(Selection.Bookmarks.Count).Nam e
    End If

    'Then find out which formfield to go to next ...
    Select Case StrCurFFld
    Case "Text1"
    StrFFldToGoTo = "Text3"
    Case "Text2"
    StrFFldToGoTo = "Text1"
    Case "Text3"
    StrFFldToGoTo = "Text2"
    End Select
    '... and go to it.
    ActiveDocument.Bookmarks(StrFFldToGoTo).Range.Fiel ds(1).Result.Select

    End Sub

    FYI I'm using Word 2002.

    Thanks for any help,

    Jim

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data entry order in form (Office 2000)

    For form check boxes and dropdown lists, you can use another method:

    ActiveDocument.FormFields("Check1").Select

    and

    ActiveDocument.FormFields("Dropdown3").Select

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •