Run Query then compare 2 fields Failure
Posted on 2014-12-07
I have the following for a field on my form but can't get it to run...
Private Sub BadgeIssued_Exit(Cancel As Integer)
If Query!qry_MG_BadgeSearch!BadgeIssued =Forms!frm_MG_3055-1!BadgeIssued Then
If Query!qry_MG_BadgeSearch!TimeOut = IsNull Then
MsgBox "Please Enter a Different Badge as that badge is already assigned to a customer...and You must sign out the badge first"
If Query!qry_MG_BadgeSearch!TimeOut = IsNotNull Then
States that qry_MG_BadgeIssued must be part of the collection. Can't figure out what is wrong...Plus the query needs to run in the background to do this procedure....
Any Help is appreciated...