MsgBox with options

[esskaykay]

I have QueryByForm with a command button that opens one of two application based on the values returned by the QBF. Currently I have a MsgBox vbYesNo code to open the proper application. However, rather than having the buttons read Yes/No I’d wish them to read Option1/Option2. If I click Option1, the code branches accordingly. Rather than the vbYesNo, I tried having a separate form. But, when it opened the second form, it did not limit the data to the results of the QBF.

Is it possible to have message box similar to Yes/No only where I could have the buttons read Option1/Option2?

Thanks,
SKK

 

[CyberLynx]

This article by Randy Birch and the code example within it will do the job nicely. It's either that or create a Form to do the job.

.

 

[esskaykay]

I've got the form created however, when it opens it does not limit the data to the result of the QBF (all records are available). How do I limit the second form to just those records selected via the QBF?

Thanks,
SKK