Hi
I have added a combo box to a screen in Dynamics SL7, but would like to hide it from all but one company, is this possible?
I added the box at 'one group' customization level which hides it from most users, but when the users in that group log into a different company db they still have the box
Thank you for any help
*This post is locked for comments
Hi Jeff
Thank you very much.
This worked like a charm.
Do you know any good resources where i can learn more VBA code?
Here's some VBA code that should do it.
While in Customize Mode, select Visual Basic Editor from the Customize menu. From the code window that appears, choose Form1 from the drop down box at the top on the left, and Load from the drop down box at the top on the right.
This should insert this into your code window:
Private Sub Form1_Load
End Sub
Between these two lines, paste this code but change the "ABC" to the CpnyID that you want this to visible in, and "cdocdesc" (in 2 places) to the name of the combo box you added.
Dim strCpnyID As String
Call GetBufferValue("bpes.CpnyID", strCpnyID)
If Trim(strCpnyID) = "ABC" Then
Call setprop("cdocdesc", PROP_VISIBLE, False)
Else
Call setprop("cdocdesc", PROP_VISIBLE, True)
End If
From the Visual Basic Editor, choose File, Close and Return to Solomon Screen and then save your customization like normally. Close the screen and re-open it and the combo box should show (or not) based on the company you are logged into.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (