Dlookup Not working

[Locopete99]

Hi Guys,

Can you look at the below and let me know why this isnt working?

Other Dlookups of the same format are working but this one gets me a runtime error

Course = DLookup("[Level]", "[Tbl_Level]", "[ID]=" & Me![Course])

So the field Im looking for is Level on Tbl level.

The ID and Course fields are both number and course is the FK of the level table in the Tbl_Current table.

So i'm trying to find the course name by looking up where the ID field of Tbl_Level is the same as the Course field of Tbl_Current.

 

[riti90]

Hi Guys,

Can you look at the below and let me know why this isnt working?

Other Dlookups of the same format are working but this one gets me a runtime error

Course = DLookup("[Level]", "[Tbl_Level]", "[ID]=" & Me![Course])

So the field Im looking for is Level on Tbl level.

The ID and Course fields are both number and course is the FK of the level table in the Tbl_Current table.

So i'm trying to find the course name by looking up where the ID field of Tbl_Level is the same as the Course field of Tbl_Current.

I'd try :

Course = DLookup("Level", "Tbl_Level", "ID= " & Me.Course)

 

[Locopete99]

Hi Riti,

Thats one of the variations I have tried, didn't work.

 

[riti90]

Hi Riti,

Thats one of the variations I have tried, didn't work.

I'm using something like this too in my db and it works just fine

strCriteria = "[DeviceID]=" & Me![DeviceID]
DevInstr1Operator = DLookup("Operator", "tblDeviceDestrInsp1", strCriteria)

Hope it helps

 

[Locopete99]

Just in case it helps I've added screen grabs of both my tables in datasheet and design view

 

[Locopete99]

Hi Riti,

Still not working for some reason.

Yet for instance I have another one that is working:

ID3 = DLookup("user", "tbl_User", "[CID]=" & Me![User])

Same basic format but one is working and one isnt and again bother CID and Me.User are number fields

 

[riti90]

Hi Riti,

Still not working for some reason.

Yet for instance I have another one that is working:

ID3 = DLookup("user", "tbl_User", "[CID]=" & Me![User])

Same basic format but one is working and one isnt and again bother CID and Me.User are number fields

check the naming probably...

Course = DLookup("[Level]", "[Tbl_Level]", "[ID]=" & Me![Course])

ambiguity with the name "Course" maybe?

 

[Locopete99]

Thanks Riti,

Turns out it didnt like the string name