Y/N field in form to open a new form if user clicks on box (Y)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 08 May 2007 16:39 GMT

I have a form A with a Y/N field. If the user clicks the box (Y) I want
another form B to open for additional data entry. I'd like to then return to
the main form A and continue. Can someone help me with this?
Thanks,
Dan

Reply to this Message

Klatuu - 08 May 2007 17:18 GMT

Use the Click event of the check box control to open form B and make form A
invisible. When you are finished with form B, make form A visible again.

Signature

Dave Hargis, Microsoft Access MVP

> I have a form A with a Y/N field. If the user clicks the box (Y) I want
> another form B to open for additional data entry. I'd like to then return to
> the main form A and continue. Can someone help me with this?
> Thanks,
> Dan

Reply to this Message

fredg - 08 May 2007 17:22 GMT

Code the Check Box AfterUpdate event:
If Me![CheckBoxName] = True then
DoCmd.OpenForm "FormB", , , , , acDialog
End If

When clicked, the FormB will open on top of FormaA. Processing on
FormA will stop.

You will need a command button on FormB to either close FormB
(DoCmd.Close acForm, "FormB")
or make it Not Visible
(Me.Visible = False).

After clicking the command button, processing on FormA will continue.
If FormB has been made not visible, remember to include code on FormA
to close it.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Dan - 08 May 2007 18:55 GMT

Thank you for you're responses.

> > I have a form A with a Y/N field. If the user clicks the box (Y) I want
> > another form B to open for additional data entry. I'd like to then return to
[quoted text clipped - 18 lines]
> If FormB has been made not visible, remember to include code on FormA
> to close it.

Reply to this Message