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)
*This post is locked for comments