slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Lookup help

Robin
Posts: 2

Lookup help Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Oct 08 8:13 AM

I've inherited a SLX installation even though I'm not a developer, but I'm the only one available with even a hint of VB experience.

Anyway, the problem I'm facing is I've been asked to make a field searchable on a form, so I've changed the label to a button called cmdDeviceID, and set an OnClick event to call a function called FunctionLookupClick (Sender)

The function looks like this

Sub FunctionLookupClick(Sender)
dim strLookup

On Error Resume Next

strLookup = ""

select case Sender.Name
case "cmdSerialNumber"
strLookup = "Opportunity:DMX Opportunity Ext.DSD Serial Number"
case "cmdSubscriptionName"
strLookup = "Opportunity:Description"
case "cmdDMXNumber"
strLookup = "Opportunity:DMX Opportunity Ext.DMX Number"
case "cmdAccount"
strLookup = "Opportunity:Account.Account"
case "cmdMultiAcct"
strLookup = "Opportunity:DMX Opportunity Ext.MultiChoice Acct Num"
case "cmdSource"
strLookup = "Opportunity:DMX Opportunity Ext.Source"
case "cmdSalesRep"
strLookup = "Opportunity:DMX Opportunity Ext.Sales Rep"
case "cmdSmartcard2"
strLookup = "Opportunity:DMX Opportunity Ext.Smart Card Version 2"
case "cmdDeviceID"
strLookup = "Opportunity:DMX Opportunity Ext.Device ID"
end select

if strLookup <> "" then
Application.BasicFunctions.DoInvoke "Lookup", strLookup
ErrorCheck "Error accessing SalesLogix VBScript functions:"
end if

End Sub

Now this function works with all the other lookups on the form but when I add the lookup for Device ID, it doesn't do anything.

I really don't know what I'm missing.

Please help

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Lookup help Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Oct 08 1:54 PM

Hi Robin,

Have you created a new Lookup on the Device ID field? Architect - Manage menu, Lookups.

Stephen
www.slxmaster.com

[Reply][Quote]

Robin
Posts: 2

Re: Lookup help Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Nov 08 2:11 AM

Thanks Stephen, that did the trick.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/27/2025 3:13:30 AM