Require a checkbox

MxPxRobbie.DeleteThis@gmail.com wrote:
> Great! Now, for the second part. I see that this makes my form
> disappear.

Define "this"?

> I am worried about my users inputting all of their
> information and forgetting to check this box, thus having to start
> over. Is there a way to take me back to the form, including all the
> information previously entered? I had something done earlier, but it
> ended up giving me duplicate entries at my bookmarks.

Can't you just *not* Hide or Unload the current form? (IOW, I suspect "this" is
actually "you.")
--
..NET: It's About Trust!
http://vfred.mvps.org

You need the following construction.

If CheckBox1.Value = False Then
MsgBox "Please discuss with your counterpart prior to filling out
this document."
Else
[Code that is populating the document]
End If


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

<MxPxRobbie RemoveThis @gmail.com> wrote in message
news:7495e25c-0636-4f9d-bcc3-b9df8d75010b@c65g2000hsa.googlegroups.com...
> Hello, I need to make a checkbox to require a check before my form can
> be submitted. I have the basic part down, but after the message box is
> clicked, my form populates the document anyway. How do I get the
> message box to go away and return to the form?
>
> If CheckBox1.Value = False Then
> MsgBox "Please discuss with your counterpart prior to filling out
> this document."
> End If
>
> I apologize for my lack of knowledge, and thank you in advance for
> your help!

You need the following construction.

If CheckBox1.Value = False Then
MsgBox "Please discuss with your counterpart prior to filling out
this document."
Exit Sub
Else
[Code that is populating the document]
End If


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

<MxPxRobbie RemoveThis @gmail.com> wrote in message
news:24bafbe5-0cf6-4c22-93d8-7ac9ad963c95@79g2000hsk.googlegroups.com...
On Jun 11, 2:17 pm, "Doug Robbins - Word MVP"
<d... RemoveThis @REMOVECAPSmvps.org> wrote:
> You need the following construction.
>
> If CheckBox1.Value = False Then
> MsgBox "Please discuss with your counterpart prior to filling out
> this document."
> Else
> [Code that is populating the document]
> End If
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> <MxPxRob... RemoveThis @gmail.com> wrote in message
>
> news:7495e25c-0636-4f9d-bcc3-b9df8d75010b@c65g2000hsa.googlegroups.com...
>
>
>
> > Hello, I need to make a checkbox to require a check before my form can
> > be submitted. I have the basic part down, but after the message box is
> > clicked, my form populates the document anyway. How do I get the
> > message box to go away and return to the form?
>
> > If CheckBox1.Value = False Then
> > MsgBox "Please discuss with your counterpart prior to filling out
> > this document."
> > End If
>
> > I apologize for my lack of knowledge, and thank you in advance for
> > your help!- Hide quoted text -
>
> - Show quoted text -

Great! Now, for the second part. I see that this makes my form
disappear. I am worried about my users inputting all of their
information and forgetting to check this box, thus having to start
over. Is there a way to take me back to the form, including all the
information previously entered? I had something done earlier, but it
ended up giving me duplicate entries at my bookmarks.

Thanks Doug!