I have this code which isn't working quite right.
Me.txtTempTransN = Me.cboTransferral
Me.txtTransN = Me.txtTempTransN & "-" & Me.txtSeqN
What is happening is the 2nd line of code is working ok except for the last part of it.
Me.TempTransN is formatted so a number like 0001 is actually showing up as "0001" because someone helped me format the field in the table as 0000.
But now the combined field (Me.txtTransN) is showing the last part as just a "1" instead of "0001" (after the "-")
How can I make it "0001" ?