Alert Forumla

[zbaker]

How do i create an alert to pop up. For example if field contains "unknown" create msgbox that pops up when the database is opened, or something of the like?

[ranman256]

if using a query, not a popup but, in the query ,make your own field : Msg:Iif([myfield]=99,"WARNING","")

if using a form ON CURRENT event:
if txtAmt = 99 then msgbox "Warning"

[zbaker]

I was creating a form for this to show the ones that fit into the parameters but the form will only pop up the warning and not provide the data

[June7]

Post form RecordSource statement. Post relevant code.
Or provide the db for analysis. Follow instructions at bottom of my post. Identify object of interest.