i want the value keyed into field to remain constant

[Guest]

i want the value keyed into field to remain constant and replicated for all
other records to be keyed in.

 

[John Vinson]

i want the value keyed into field to remain constant and replicated for all
other records to be keyed in.

If you use a Form (as you should be doing - table datasheets have VERY
limited capabilities) you can set the DefaultValue property of a
textbox in that textbox's AfterUpdate event. Click the ... icon by the
event, invoke the Code Builder, and set the code to something like
this (using the name of your form control in place of MyTextbox):

Private Sub MyTextbox_AfterUpdate()
Me!MyTextbox.DefaultValue = Chr(34) & Me!MyTextbox & Chr(34)
End Sub

Note that if you mean that *every record in the entire table* should
have the same value, permanently, you might want to ask whether this
field needs to exist at all!

John W. Vinson[MVP]