Data Validation Challenge

R

Renee

Any suggestions on how to create a data validation action for the following
using the before update event of the form:

Tracking Customer Confirmations:
I want to search the table, for a record matching the txtClient and ApptNum
controls, and then verify the attempt entry is valid. I.E. If they select
"2nd", and there is no existing record of "1st", prompt a MsgBox and cancel
the update. The attempt choices are 1st, 2nd, & 3rd.

Here is what I have been working on:
If Not IsNull(DLookup("[txtAttempt]", "tbl_Confirm", _
"[txtClientID] = '" & Me.txtClientID & "'" & _
" And [ApptNum] = " & Me.ApptNum & _
" And [txtAttempt] ..............................)) Then
MsgBox ".................", vbOKOnly
cancel = True
End If

Thank you for your time,
Renee
 
Top