alert box? Confirmation box? or MsgBox?

[Twig]

I have a situation here that I don't know which boxes can help me. I have read the documents regarding these boxes but it seems none of them satisfy my requirement.

My problem is I need an alert box or message box (or whatever popup box that would satisfy my requirement) that will prompt the user to make a selection.
I only need 2 buttons! Each button will prompt user to a different report!

Please help me, if anyone have any suggestions.

Thanks

 

[FoxProProgrammer]

You can't use the MsgBox Function for that purpose because the text in the buttons can only be set to Ok, Cancel, Abort, Retry, Ignore, Yes, and No. It is simple enough to create a small dialog box that contains two buttons. You would open the appropriate report in the On Click event of each button. Use DoCmd.OpenForm formname,,,,, acDialog to open the form. The acDialog option opens the form as a popup style and suspends the code in the calling form until the user closes the popup form. dz
dzaccess@yahoo.com