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

[Guest]

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

 

[Guest]

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.

 

[fredg]

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

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.

 

[Guest]

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
the main form A and continue. Can someone help me with this?
Thanks,
Dan

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.