Okay so I feel like an idiot b/c I can't get this to work but I'm out of ideas. When put into SQL, it works fine, but when on a control, it has issues.
Here's what I have: =DLookUp("Location","tbl_User, tbl_AssetLocation","tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND tbl_User.UserID = forms!frm_UpdateAssetForm.Userid")
and here's the SQL version that works fine:
SELECT Location FROM tbl_User, tbl_AssetLocation WHERE tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND tbl_User.UserID = forms!frm_UpdateAssetForm.Userid;
The fact that the SQL works but the dLookUp says "#Error" is very confusing to me. I have all the above refrenced tables, fields, etc (obviously since the SQL works)
Any help is greatly appreciated, thank you.
Here's what I have: =DLookUp("Location","tbl_User, tbl_AssetLocation","tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND tbl_User.UserID = forms!frm_UpdateAssetForm.Userid")
and here's the SQL version that works fine:
SELECT Location FROM tbl_User, tbl_AssetLocation WHERE tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND tbl_User.UserID = forms!frm_UpdateAssetForm.Userid;
The fact that the SQL works but the dLookUp says "#Error" is very confusing to me. I have all the above refrenced tables, fields, etc (obviously since the SQL works)
Any help is greatly appreciated, thank you.