Show form modal???

[pdbowling]

Hi all,
I'm trying to, at a button click, show another form with a yes and no button on it. Have the user click one and then the form needs to go away and return focus to the parent.... what is wrong with my code. The form just flashes on and is immediately gone.
Thanks everyone.
PB


Private Sub Command54_Click()

Form_frmReminder.SetFocus
Form_frmReminder.Visible = True

If (Form_frmReminder.myAnswer) Then 'a boolean
Form_frmReminder.Visible = False
doYesterday 'a sub previously written
Else
Form_frmReminder.Visible = False
End If

End Sub

 

[MattS]

Regardless of the value of MyAnswer you are setting the forms visible property to false. That is why it just flashes on the screen and dissapears.

 

[pdbowling]

Yes

I understand that, I was just under the impression that the code was supposed to ... wait.... while the other window was in focus..... I guess I am wrong.

I'll try moving the if then to the button_clicks on the form.
Thanks
PB

 

[SforSoftware]

If you open the form from code then you can use:
DoCmd.OpenForm "MyForm", , , , , acDialog

then the code will wait until MyForm is closed

 

[pdbowling]

Whew!!

Gee god, thank you.
I thought that was an easy question.
The differences between VB and Access VB are subtle but quite important.
Many, many thank yous.
PB