Making a field stay the same

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.
 
J

John W. Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top