DLookUp

[Sentry]

Im wondoring if there is any reason why a DLookUp would not have access to a table. Or for that matter is there any reason why a query would not be able to read a table. It works almost all of the time but I think that for some reason ocationaly it isn't working. It is a posibile solution to a bug and I just want to rule it out if it isn't an option.

 

[KenHigg]

What does it do, hang up or throw an error message?

kh

 

[Sentry]

It just doesn't do anything. I'm not even sure if this is the problem but for some reason a process is not working and I'm trying to narrow it down. If there is any way for it to just not work w/o an error.

 

[WayneRyan]

Sentry,

The DLookUp will return the requested string or Null. But it will return
something.

Have you single-stepped through the code with the Debugger?

Wayne

 

[Sentry]

I have single stepped. And it did work. The problem is that it messes up in a multi user environment and it is really hard to recreate. Maybe you could take a look at my other post about Record Locking and SQL VBA Code. It explains in a little more detail what the problem is and what we are experienceing. Thanks for the help. I had fogotten that about DLookUp.

Sentry