Dynamics Community Forum Thread Details

VBA code causing record not able to show saved details if retrived using lookup button

I have VBA code in Assembly Entry windows that will set the user defined field 1 of Assembly Document Detail Entry windows to a value based on the Document Number. The code works fine.

Problem is that if user use Document Number lookup to retrieve a record, it will NOT display the saved details. But if the document number is entered manually or moved using the next/prior record button, it works OK.

Can someone help look at what I did wrong?

thanks in advance.

below my VBA code:

*************

Dim xDOCNUMBER As String

Private Sub DocumentNumber_Changed()

If Me.DocumentNumber <> "" Then

If xDOCNUMBER <> Me.DocumentNumber Then

Dim xUSR1string As String, xUSR1pos As Integer

xUSR1pos = InStr(1, Me.DocumentNumber, "-")

If xUSR1pos >= 2 Then

xUSR1string = Trim(Left(Me.DocumentNumber, xUSR1pos - 1))