I'm am attempting to do some customization on the Receipts form in SL and I'm a bit lost.
My code is in the Spread1_LineGotFocus event but when the row loses focus the value disappears.How do I achieve this?any help will be appreciated
Dim str2 As String Dim Cur As Integer Dim SQL As String
Dim myDescription As myDescription
str2 = GetObjectValue("cSpecLotSer") str2 = Trim(str2) 'MsgBox (str2) ' Call SetObjectValue("xuser1", str2)
SQL = "select MfgrLotSerNbr from LotSerMst where LotSerNbr='" & Trim(RTrim(str2)) & "'" Call SqlFetch1(Cur, SQL, myDescription, LenB(myDescription)) Call SetObjectValue("xuser1", myDescription.testString) SqlFree (Cur) Close (Cur)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148