Activate the check box with a text field.

[Blue Sky]

Group,

Hope all is well. This should be a simple question. I am still in the
process of developing an automated form to gather information. The form is
mostly composed of text fields interjected with a few check boxes. I have
been using the VB Editor to generate the text field code. My question is
this. When I run the form all the text macros are operable in "dumping" the
requested info into the set fields. But the program "skips" over the check
box section. How does one program the macro to let the user pick his/her
choice and then go on to the next text field. I have an example given below.

INFO HERE 1: (if applicable) INFO1

INFO HERE 2: (check one) 0 AAA 0 BBB 0 CCC 0 DDD 0 EEE

INFO HERE 1: (if applicable) INFO2

Any hints would be greatly appreciated.

Blue Sky...

 

[Word Heretic]

G'day "Blue Sky" <[email protected]>,

I am so sorry, I simply cannot understand your request here. Could you
please try again with a more straight-forward explanation of what u r
doing and what is happening.

Spanish aunts,

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Blue Sky reckoned:

 

[David Sisson]

Since you didn't provide any code, it's difficult to offer any help.
But see if this answers your question.
http://www.word.mvps.org/faqs/tblsfldsfms/SetTabOrder.htm

 

[Blue Sky]

The Infamous Word Heretic,

Here are the specifics. It's a Word form that has text fields (example
below is INFO1 and INFO2) between a field with a check box (example is
INFOHERE 2). The Word form works for the text fields but jumps over the
section for the check boxes. What I would like the form to do is allow the
user to check the appropriate choice in the form (e.g. INFOHERE 2) and then
continue on with the text field macro for INFO2. I have included the code
below for the two text fields but in the form is a check box where the user
will check the sample type. Do I need to create some code that will prompt
the user the pick the appropriate choice? Hope this helps.

Sub mBatchnum()

'This will get information about the batch number

vBatch = InputBox(Prompt:="Provide the Batch Number")

ActiveDocument.FormFields("bkBatch").Result = vBatch

'This is where I want the macro to allow the user to pick a sample type by a
check box routine

End Sub

Sub mStabstore()

'This will get information about the stability conditions

vStab = InputBox(Prompt:="Provide the Stability Conditions and Time
Point")

ActiveDocument.FormFields("bkStabcond").Result = vStab

End Sub

 

[David Sisson]

I tried to replicate your problem locally. If I had...

FormField1
Checkbox1 Checkbox2 ...3 4 5
Formfield2

I could tab from FF1 to CB1, 2,3... FF2 with no problem.

However if I placed the checkboxes in a textframe, I could not tab from
FF1 to CB1. It would jump to FF2 as you describe.

The solution would be to set the focus from the bottom of FF1 event
routine, (as your suggestion indicates), but I had no luck in finding a
solution. (Through searching on Google) Maybe someone else can help
here?

IMHO, this would be a prime case for a userform. You could collect all
the data in one window and paste it into the form. You would have much
more control over the data entry.