Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers

I added Option Explicit and compiled. There are no errors and no missing References

Example of text box that works:
=DLookUp("[name]","Provider","")

Example of text box that does not work:
=DLookUp("[city]","Provider","") & " " & DLookUp("[state]","Provider","") & " " & Left$(DLookUp("[postalcode]","Provider",""),5)

All text boxes that are comprised of more than one input field are resulting in #Name? error in Access 2016.

The BE and FE are both in Access 2003. The user is using Access 2016 run time.

Sarah

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116231) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_