dlookup syntax question

[stuckagain1]

can you have more than one criteria in the dlookup expression? i can never get it to work if i need two pieces of criteria....

dlookup([id],"table","field1=me.field1 and field2=me.field2")

me.field1 and me.field2 are on my form (and in the table) and i'm trying check after field1 is updated if field1 and field2 's data matches the data in the table, ie it would be a duplicate entry......

thanks-

 

[MrBillSC]

Try this in Field1_AfterUpdate():

Dim Lkup As Variant
Dim MsgBoxValue As Integer

Lkup = DLookup("[id]","table","field1="Forms!MyForm!field1 and "field2="Forms!MyForm!field2")

If Not IsNull(Lkup) Then
MsgBoxValue=MsgBox("This is a duplicate record",vbOKOnly,"Duplicate Record:")
EndIf
End Sub

MrBill

 

[PHV]

DLookUp("id", "table", "field1='" & Me!control1 & "' and field2='" & Me!control2 & "'")


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stuckagain1]

thanks--

this is what i have and i get a data type mismatch in criteria error.......argghh

If IsNull(DLookup("id", "outreach", "outreach_date='" & Me!OUTREACH_DATE & "' and ID='" & Me!ID & "'")) Then

is it the date field??

 

[PHV]

If outreach_date is defined as DateTime in outreach:
If IsNull(DLookup("id", "outreach", "outreach_date=#" & Me!OUTREACH_DATE & "# and ID='" & Me!ID & "'")) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stuckagain1]

thank you--it's working!