Update - Create a pop-up Message box to display results?

RitaMoloney

Registered User.
Local time
Yesterday, 21:31
Joined
May 6, 2004
Messages
50
Hi,

Not sure if I am suppose to start a new thread for this question or not but anyway, this question refers to an old thread called;
Create a pop-up Message box to display results?

http://www.access-programmers.co.uk/forums/showthread.php?t=67460

When you open frmStoreRoom, you are asked if you want to check for under stocked parts? Click yes, it runs a check to see if there are any stock that needs to be re-ordered. If there is a message box (frmMessage) pops-up displaying the name of the part(s) and the amount in stock. On clicking on a part it takes you to the order form (frmReOrder), where you re-order the part and press the close button (ok / cancel) which will take you back to frmMessage to amend the next part. When all parts are up-to-date the frmReOrder form closes (by pressing ok/cancel button).

___ 's Avatar sent an attached file that solved the problem.

But a loophole has been found in it and I was wondering if anyone could solve it.

If you just want to order or edit a part. You open the frmReOrder (there is only a few fields in his example but the would be more fields like Order Date, Quantity etc). After you have finished and you want to close the frmReOrder. you press the Ok / Cancel button. You get a run-time error '2450', can't find the frmMessage.

Has anyone, any idea on how to get around this problem?

Thanks in advance for you help,
P.S. I have attached the file.
 

Attachments

You're trying to make a form visible when it's not open... Check to see if it's open first...

???
 
Hi,

This would be done by an If statement, am I right? I tried a few different ways but keep doing something wrong. I am not very good at vb. I would really appreciate it if you could let me know how this statement works.

Thanks in advance,
 

Users who are viewing this thread

Back
Top Bottom