There is no such thing in Access as Auto Complete. The closest there is is
the Auto Expand property of a combo box which moves to the first row matching
what has been typed in for each keystroke. But, that doesn't sound like what
you want.
Saying you don't want to link to a table or use a combo box because things
change too quickly really makes no sense. If you use a table or query as the
row source of a combo it is easy to add a new item to the list using the Not
In List event of the combo.
If what you are saying is you want to be reuse the the value entered in a
control for the next new record and continue using that value until a user
changes it., then you can assign the value to the control's Default Value
property in the control's After Update event:
Private Sub txtFacility_AfterUpdate()
If Me.NewRecord Then
Me.txtFacility.DefaultValue = Me.txtFacility
End If
End Sub