approach for flagging to user of available data

[Mark Kubicki]

I have a form (that is used to customized products used in a specific job).
I've added to the form a new control button that opens a pop-up form. The
purpose of the pop-up is provide users a method of sharing information about
the use of a product (in-house notes such as: "the red color option is
really an awfull hot pink", "they have been talking about possibly
discontinuing this product, -ask before using")

Because this is new to the mdb, most of the products will not "yet" have
notes, and I want to add a flag that flags the user when a product does have
notes. I thought it might be a picture box (with an "!" similar to the one
used in a message box) that is only visible if the len() of the field (with
the comments) is >0; however this would mean checking the main data base
everytime the record changed and consequently a lot of network traffic...

Is there a better or a standard way of handling this design request?

thanks in advance,
Mark

 

[Golfinray]

I would try adding a yes/no field to my table then put that yes/no in your
form by using a checkbox. If the checkbox is checked there is additional
information.