Making a field stay the same

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have field in the form called Batch_Id the processor enters this when they
start each batch.
How do I make it so the that Field will not change and continue on to the
next form until changed. Once changed then I want it to copy the new one
going forward.
 
I have field in the form called Batch_Id the processor enters this when they
start each batch.
How do I make it so the that Field will not change and continue on to the
next form until changed. Once changed then I want it to copy the new one
going forward.
Click to expand...

You can put code in the Batch_ID textbox's AfterUpdate event:

Private Sub Batch_ID_AfterUpdate()
Me!Batch_ID.DefaultValue = Chr(34) & Me!Batch_ID & Chr(34)
End Sub

The Chr(34) is a quotemark ", required since the default value property needs
to be a string.
 
Back
Top