#Name? error after setting default value (97 / SR-2)

[jols]

I have a textbox on a form that has its default value set automatically in the after update of the text box using this code:
txtDocketNumber.DefaultValue = txtDocketNumber.Text
It has been working fine when they type a number in the textbox, but as soon as they type in a letter and then go to a new record the box is displaying the #Name? error.

The data type is text in the table. Can anyone see what I'm doing wrong?
I would greatly appreciate some help with this.
Thanks,
Jols

[Jack Cowley]

If your pupose is to carry forward to the next record data from this record then I might suggest this method instead:

In the After Update event of the field in question put code similar to this:

If Not IsNull(FieldName) Or [FieldName] = "" Then
Me.FieldName.Tag = Me.FieldName.Value
End If

In the On Enter event of the same field:

If Not IsNull(Me.FieldName.Tag) Or Me.FieldName.Tag = "" Then
Me.FieldName.Value = Me.FieldName.Tag
End If

This code will only last as long as the form is open. When you come back to it you will have to start a new number but it will carry forward again until you leave the form.

hth,
Jack

[charlotte]

I'd suggest you follow Jack's advice and use the Tag property instead. Part of your problem is probably the use of the Text property, which is only available in Access while the control has the focus. When you move to a new record, the focus normally shifts to the first control in the tab order.

[jols]

Thanks Jack!! It worked like a charm!

[MarkLiquorman]

The problem is, Access is interpreting the letters in the Default value as a variable. You need to surround them with quotes. Try this instead, should work with both text and numbers:

txtDocketNumber.DefaultValue = chr(34) & txtDocketNumber & chr(34)