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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
Click to expand...

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.
 
Thank you for you're responses.


fredg said:
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
Click to expand...

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.
Click to expand...
 
Back
Top