Field default value setting

[G Marshall]

Hello
I have an “orders” table that has a column for buying order numbers. There can be many orders using the same buying order number .

To save additional typing on the input form for this table, during data entry, I want the value of this field to default to the previous buying order number each time.

I would appreciate if someone could point me in the right direction as to what to enter in the field default value to achieve this.

Cheers

Gerald

 

[bat17]

Something like

Private Sub Orders_AfterUpdate()
Me.Orders.Tag = Me.Orders
End Sub
Private Sub Form_BeforeInsert(Cancel As Integer)
Me.Orders= Me.Orders.Tag
End Sub

shoud do it.

This does not actualy repeat the last order number in the recordset but saves the last one typed in.usualy the same in practice. Also you can bring up the previous entry with the kb short cut ctrl-'

HTH

Peter

 

[G Marshall]

Thanks for that info Peter
Much appreciated.

Gerald