Syntax Problem

[atrium]

I can't get this to work

If (DLookup("DdSchedId", "DdSchedules", "[MatterId] = " & Me.MatterIdFld) = True And ([Status] = "Not Active")) Then

Can anyone help please

 

[theDBguy]

I don't see anything wrong with it. Can you post a screenshot?

 

[bastanu]

Is [DdSchedId] a boolean field or an actual number (ID)? The Dlookup would return the actual ID not True. If you want to check if there is a SheduleID for a MatterID you would do: If DCount("*","DdSchedules", "[MatterId] = " & Me.MatterIdFld) >0 AND ... Then

Cheers,

 

[Eugene-LS]

If (DLookup("DdSchedId", "DdSchedules", "[MatterId] = " & Me.MatterIdFld) = True And ([Status] = "Not Active")) Then

Try:

If DLookup("DdSchedId", "DdSchedules", "([MatterId] = " & Me.MatterIdFld & ") And (Status = 'Not Active')") Then