You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
-
Nothing is updated bacause of the If rs!DogID = ""
Change that to If IsNull(rs!DogID)
-
Cross posted at https://www.accessforums.net/showthread.php?t=90997
-
Like this?
Dim companyF As String
companyF = Left([Company_Name], 2)
Me.Assigned_To = DLookup("[Analyst]", "[tbl_company_analysts]"...
-
You need to remove the =.
