Pop up message on form

B

Brook

Here is what I am trying to accomplish:

I have set up a Call Center database to track customer
calls:

I have frmCallCenter and frmDetails. When the user is in
the frmCallCenter they only see a call summary (CompanyID,
CallerName, and Company Name (company name is a drop down
box and CompanyID is filled in based on the Company Name)
when the user clicks a command button -- they see more
details on that particular call (type of call, date of
call, lenght call, call notes, etc).

I also have a tblSpecialNotices, that is based on the
CompanyID, and contains the company name and any special
notes that apply to that company.

What I am trying to do is set up a Message box that when
the user enters the Call Details a message box will pop up
giving them any special notes for that Company (based on
the CompanyId from the tblSpecialNotices and the CompanyID
from the frmCallDetails).

Hope this is clear and I hope someone can help,

Thanks,

Brook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top