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

hi Sara,

perhaps try the quoted text?

~~~

you don't need 3 DLookups, or even one since it appears that dFirst will work too. Try this:

=DFirst("[city] & ' ' & [state] & ' ' & Left( nz( [postalcode],''),5)","Provider")

Runtime can be picky. Sometimes you just have to give in and do things differently.

good luck

kind regards,
crystal

On 7/3/2022 9:44 PM, novice012000 wrote:

When I respond show the thread. How? I see 'show quoted text' ,but it does not include the prior posts.

Yes as I mentioned, it works for me in 2003, it is only an issue for the user running 2016 run time.

Sarah