repeat field value until changed

  • Thread starter Thread starter MikeO
  • Start date Start date
M

MikeO

I have a form to order, issue, receive products etc. The user first selects
the "trantype" to issue or receive a product. They choose the "trantype" from
a combo box and then move to the next field. How can I keep the field for the
"trantype" the same as the previous trantype until changed?
This data is entered into a table and then updated to the transaction
history.
Thank you,
Mike O
 
In the AfterUpdate event of the trantype field, use code like:

Private Sub trantype_AfterUpdate()

Me.trantype.DefaultValue = Chr$(34) & Me.trantype & Chr$(34)

End Sub
 
That works well, Thank you.
I tried some other options but I was not able to get them to work.
Your code will take care of it.

Thak you.
Mike O.
 
Back
Top