Dlookup

[arage]

Dlookup
I’m fine tuning a report & am using the dlookup function in the detail sections onFormat event. I typed this code:

intCollCod = DLookup("Code", "Collections", Title = Me.Title)

but this isn’t executing correctly, intCollCod keeps returning the value of the first collection in the domain, rather than the code associated with me.Title as in the the criteria. Me.Title appears as a field in this section as well. Would appreciate any help.

 

[Nouba]

assuming that Title is of type text, you could try

intCollCod = DLookup("Code", "Collections", "[Title] = '" & Me!Title & "'")

HTH nouba

 

[Oldsoftboss]

Bit of info for ya
Dave