AfterUpdate Problem

[Guest]

I need to flash an "RE-ORDER ALERT" message after inventory level falls below
re-order level. The message only flashes up when I move to a next record
and back after a DoCmd.Save.

I need the message to flash immediate after a Save.

Note. The message is a flashing label on the form.


Thank you.

 

[Guest]

Perhaps you could code it to actually flash before DoCmd.Save is processed.
Once you're into that code string, it will be run.

Or, maybe consider a Message Box. I like this idea because it forces the
user to interact with the reorder message. No one can say "I didn't notice
it."

Sharkbyte

 

[Tony Toews [MVP]]

I need to flash an "RE-ORDER ALERT" message after inventory level falls below
re-order level. The message only flashes up when I move to a next record
and back after a DoCmd.Save.

Sharkbyte's comment about a msgbox is a good one.

But I'd also put a menu item on the main form running a form based on
a query showing all items which require reordering. This way it's
real easy for the appropriate person to take a look once a day or so
and do the reordering.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/