Conditional Pop-Up Message

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I am using Access 2000 and have a database that was
created by an outside consulting firm. I would like to
add a Pop-Up Message Box to notify the user that they
have entered an inactive consultant ID in an input form.

Logically I woul like to use an "If" statement ...... can
anyone provide me any assitance witht his?
 
You can use the BeforeUpdate (if you want the user to select a different
consultant) or the AfterUpdate of the Control txtConsultantID with something
like:

If DLookUp("[fldbuactivestatus]", "tblConsultant", _
"[ConsultantID] = " & Me.txtConsultantID) = 91 Then
MsgBox "Inactive Consultant"
... {whatever else}
End If

Replace with suitable Table name, Field name & Control name from your
database.
 
Back
Top