field filling

[mon]

Hi dear helpers
What property do I invoke to default a value to the
previous record's value. ie Jobnumber field is 55555 and
the next record is filled with 55555? Is that clear? sorry
if it isn't.
Thanks Mon

 

[Duane Hookom]

All data entry should be done through forms. You can set the default value
of a text box to its current value in the After Update event of the text
box.

Me.txtJobNumber.DefaultValue = Me.txtJobNumber
if JobNumber is a text field then use:
Me.txtJobNumber.DefaultValue ="""" & Me.txtJobNumber & """"

 

[Duane Hookom]

Post the code you are using.

 

[Duane Hookom]

Your text box name is txtJobNumber and your code is the after update event
of the text box?
Can you enter a value into the text box?