Flagging a customer, or pop up message possible?

[balderman]

I have tried googling this and haven't found exactly what I am looking for.



Is it possible to "flag" a customer profile with a pop up message? Like when we search for the customer, a message will pop up giving some sort of warning, like when it's a customer who owes money or has given problems in the past? Something that would be attached to that one record only?

[aytee111]

Is this happening when you select a customer on a form and display their data? Or a query, or report? What would be the trigger for the event, for the message to pop up? You can also have a text box with conditional formatting.

[balderman]

Just when you go to the record a message would pop up? Is that possible?

[aytee111]

However you are selecting and retrieving the customer, in whichever event that is happening, add a piece of code to check the values and show a message.

[Micron]

Sounds like a feature that can quickly become annoying, IMHO. Why not have the issues in their own table, CustID_Fk as the foreign key to tlbCustomers and list the issues in records along with other pertinent details, such as the date of occurrence, type, who logged, etc. and present the issues as a continuous or datasheet subfrm on the main form? The event you use for the other idea could drive you nuts. If it's the form current event, the dialog will pop up for every record where there are issues. User might only want to see other info about the customer (maybe like when they became one) and would get an annoying prompt each view. So you might use a button to show issues instead. Then if I don't click it, what's the point of only revealing such warnings if I think to do so?

If you don't like the idea of showing a subform (or even just a textbox warning there are issues) then hide the subform or textbox if it's null. The idea of not realizing something is wrong without taking action to reveal it, or revealing it in a way that requires interaction doesn't sound great to me.