DLookUp

[Subwind]

Has anyone else had an issue in the last week where a DLookUp is no longer working?

I have changed no code in my database, I have made no changes to anything, but last week it worked, this week it doesn't.

=DLookUp("[RATE]","tblSageCurrency","[CODE] = 'USD'")



Above is the sample, this has no reason to be changed, as it does nothing but display a value. Yet now, it does not show anything.

Was there an update that may have stopped this working?

~Matt

[Subwind]

Weirdly enough, the below code DOES work.

Me.Caption = "User: " & DLookup("EmployeeFirstName", "tblEmployees", "EmployeeFirstName = GetUserName()") & " - Form: Dashboard"

And that DLookUp has not changed either.

~Matt

[Subwind]

As an addition, the status bar at the bottom shows "Calculating...." for the entire time the forms with the broken DLookUp is open.

I cannot make sense of it that some DLookUp are still working, but others are not, yet nothing has been altered in the code.

~Matt

[Subwind]

Stupid piece of junk windows, it now works, without anything being changed.....

[akhmadahdiyat]

so it solved, junk windows..