Dlookup in query

[Bertrand82]

Hi,



I would like to create a Dlookup function in [qryAnimals]

The purpose of the function is to retrieve te correct "animal" from [tblAnimals] matched by ID.

Please use my attached file.

Br Betrand

[June7]

Something wrong with this db. It is not recognizing the intrinsic DLookup function. This should work but isn't:

SELECT tblAnimals.ID, DLookUp("Animal","tblAnimals","ID=" & [ID]) AS DLookupFunction FROM tblAnimals;

[DatabaseMakers]

It's because the project is named DLookUp!~)

[June7]

I renamed the database. Query still doesn't work.

[DatabaseMakers]

You need to rename the Project in the vba editor properties.

[DatabaseMakers]

You can keep the name of the database.

[June7]

Okay, that did it. Never ran into this before.

[DatabaseMakers]

Try and name a public function the same as the project name and run it... It will not work!~)

[June7]

I knew about naming conflicts, but never encountered and just didn't come to mind.

[Bertrand82]

Thank you guys, excellent support!