Property: On Not In List

[tgall]

Short Ride: Event procedure on "On Not In List" property works on standalone computer, but not on
a corporate computer. Why? How do I troubleshoot?

Scenic View: At my job, they downloaded Microsoft's Access Call Tracker Template. The process path
is Call List form ==> Call Details form. On the Call Details form is a field entitled Caller.

The Call Tracker template has been modified so that if the Caller is not in the Customer table, then the
Customer Details form pops up with the company information filled in. The end user just enters the


caller's name on the popup.

This action is done via the "On Not in List" property for the Caller field on the Call Details form. It
worked on the corporate computer up until recently. The popup form no longer shows the company
information. Instead of a blank field for Caller, the code displays a record ID.

Yet, when I download the program onto my offline laptop, it works correctly. Troubleshooting actions
I took:
* I backtracked on both computers. Both have the same VBA, same queries, same tables EXCEPT
the corporate computer pulls the customer table from SQL Server.
* I asked whether IT had made changes to the SQL Server database or to the network. They say no.

Then why does the code continue to work on my standalone computer and not the corporate computer?

[CJ_London]

perhaps you have not identified an index when you linked to sql server

[tgall]

Intrigued. Educate me. Is the "Index" on the Access side or the SQL Server side?

[CJ_London]

the sql table need to be indexed (PK/unique) and when you link to the table from Access, you need to identify the field - you are prompted as part of the linking process.

see this link for more info - see towards bottom of step 2

https://support.office.com/en-us/art...7-f369b78d3db8

[Missinglinq]

Does any code execute in the Form, on the corporate computer? In version 2007 and later, when no VBA code executes, the problem is usually that the folder holding the database hasn’t been designated as a "Trusted" location.

To "Trust" your folder, on v2007, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

Location for this may differ for alter versions.

Linq ;0)>

[tgall]

Missinglinq, good point concerning "Trusted" location. I don't believe, however, that's the culprit.
Other code does execute. And, in fact, the VBA for "On Not In List" does execute in the
corporate computer, it just doesn't execute correctly.

The good AccessForum comments had me thinking that the Access database was
corrupted. So, I imported the objects into a new Access shell on the corporate computer.
The same anomaly reoccurred: works correctly on my standalone; works wonky on the
corporate computer.

[Missinglinq]

...in fact, the VBA for "On Not In List" does execute in the corporate computer, it just doesn't execute correctly...

So, what code are you running in the Not In List event, and how, exactly, doesn't it execute correctly?

Linq ;0)>