Notifications
Announcements
*This post is locked for comments
In v2010 I believe you can set the lookup to show certain columns of informaiton and then set that "view" as the default. This functionality is per user so it would have to be done on everyone's machine.
You could also do some modifier with VBA or VST code to manipulate the display and deploy it on all the workstations.
Regards,
Aaron
I've done this before - Aaron is right, the trick can be using VBA set to the window's open event to simulate changing the sort. It happens instantly, totally undetectable.
I wrote a little blurb on it and have a sample package file over at my blog:
gpworking.com/.../changing-the-lookup-defaults
---
D. Valade
http://gpworking.com
Does anyone know if GP 2010 has the ability to create custom views that show a different column by default, as suggested by Aaron above? If so, how is it done? I don't want ot use custom code, because some user prefer sorting by item number, while others use description.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
