Locopete99
Registered User.
- Local time
- Today, 02:20
- Joined
- Jul 11, 2016
- Messages
- 163
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
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.
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
Code:
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.