DLookup with linked tables. (1 Viewer)

BlueIshDan

☠
Local time
Yesterday, 22:32
Joined
May 15, 2014
Messages
1,122
Anyone have any idea as to why this wont work. I wasn't able to find any information online. I'm sure there is some but I'm a bit groggy today...

The image below describes the scope of the issue.

The function is called upon in the onLoad event of frmMain.




Thanks!
Blue
 

Attachments

  • Capture.JPG
    Capture.JPG
    46.4 KB · Views: 810

vbaInet

AWF VIP
Local time
Today, 01:32
Joined
Jan 22, 2010
Messages
26,374
In my view there are two possibilities Dan:

1. The link hasn't been properly established before the DLookup() is called. So try running it as a standalone and see if it works.
2. Try this wrapping it in square brackets:
Code:
etc... Dlookup("[id]", "[users]", "[username]... etc")
 

BlueIshDan

☠
Local time
Yesterday, 22:32
Joined
May 15, 2014
Messages
1,122
Oh by God you're right haha.

I started with a singular database for development and in the process of splitting it up between front end and back end I linked the tables to the main database, before switching them over to the backend one.

Derp. Thanks dude :)
 

Users who are viewing this thread

Top Bottom