field filling

  • Thread starter Thread starter mon
  • Start date Start date
M

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
 
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 & """"
 
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?
 
Back
Top