Pop-up messages for a record?

[Elise]

I'm using MS Access 2000. I was wondering if there is any way to get a
pop-up message to come up if I open specific records.

For example, I use the database to track books that a library ordersI
input order information, and then later check the records of the books
that have been received. Sometimes a patron requests that we purchase
a book. I keep a note of who wants the book so that when it arrives, I
can let the patron know. I can usually remember which books these are,
but sometimes we get a number of these requests at once, or sometimes
a book takes a while to come in and I have forgotten.

I would like to have it that I can add a message to a book's record so
that when I next open it (to show that it has arrived), I'll get a pop-
up message or have the record flagged in some way to let me know that
I need to contact a patron.

Sorry, that was very wordy. I'm hoping there is some easy way to do
this for specific records (rather than all).

Thank you!
--Elise

 

[Dorian]

Yes, that is easily done.
In the Current event for the form, simply make whatever check you need and
then display the message.
The column you are checking against (probably the message itself) will need
to be a hidden control on the screen (property: visible = false)
So if you have the hidden control be MyMsg, the code would be (in Current
event)
If NZ(Me!MyMsg,vbnullstring) <> vbnullstring then
Msgbox Me!MyMsg,,"Message"
End If
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".