VBA ERROR: FIELD CAN NOT BE UPDATED

[SGTSweety]

Why will line not work?

frm_MailAddr = DLookup("LocAddr", "[dbo_real_master]", "[dbo_real_master]![PIN]= [frm_PINInput]")


Attempting to populate fields on a form based on user input of property ID [frm_PINInput]. In this instance the field being populated is frm_MailAdddr. When cursor is atop this line in VB editor, a tool tip pops up with "frm_MailAddr = 3414 IVYLINK PL " which is the correct result. Code is part of "on exit event" of frm_PINInput field, but gives error FIELD CAN NOT BE UPDATED when run.

Thanks in advance for your wisdom and assistance.

"LocAddr" is field in linked table SQL database
"dbo_real_master" is linked table SQL database
"frm_PINInput" is user input

 

[randy700]

How about this?

frm[COLOR=red]![/color]MailAddr = DLookup("LocAddr", "[dbo_real_master]", "[dbo_real_master][COLOR=red].[/color][PIN]= [COLOR=red]' " & [/color][frm[COLOR=red]![/color]PINInput][COLOR=red] & ' [/color]")

If PIN is numeric...

frm[COLOR=red]![/color]MailAddr = DLookup("LocAddr", "[dbo_real_master]", "[dbo_real_master][COLOR=red].[/color][PIN]= [COLOR=red] " & [/color][frm[COLOR=red]![/color]PINInput])

Randy

 

[SGTSweety]

Thanks...
for your time and advise,

This did it.

Steven Boyer