Opening and Closing Popup Form

[tmdrake]

[Z{Moderator's Comment: This thread was split from the orignial:
> Form Creation Help}]


Got it to work, but now I have a couple of questions regarding the form. I turn the form into a popup, which works great. However, how to I get the initials and the Yes/No choice to save in the table. The form's control source is a table named "EventT" with colums to record the choice and the initals. But when I run the form the choices and initals don't record in the table.

Thanks
Toni

[Seth Schrock]

Ah, so then this is a bound form. You just need to edit the control source of your Initials textbox to the proper field. If you click in the control source property, you will get a drop down list of the possible fields. In your buttons' OnClick events, you can reference the field to set it to the value you need (I know this works if the recordsource is a query, but I'm not sure if it works on a table).

[tmdrake]

Thanks Seth, that worked. Now how do I get the popup form to close on selecting Okay. Below is the code I've come up with so far, but I'm not sure where to go from here.

I need for it to open a form, then close the popup form;

Private Sub Yes_Click()
      DoCmd.OpenForm.:GeneralTabPullTest:

Thank you very much for helping me.

[tmdrake]

Opening and Closing Popup Form would be a good title.

[Seth Schrock]

Assuming the name of your form is frmPopup,

DoCmd.Close acForm, "frmPopup"

You can put this in the OnClick event of any of your buttons.

[tmdrake]

Thanks Seth, this worked perfectly.