incrementing values based on records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form based on a table which has an Order ID number. Every time I make a new record I want the value to just increase by 1 (based on the last record in the table). How do I do this?
 
Hi,
This might works for you:

Put this in the default value for the control that is bound to
your OrderId field:
=DMax("OrderId","yourTable") + 1

--
HTH
Dan Artuso, Access MVP


rendicil said:
I have a form based on a table which has an Order ID number. Every time I make a new record I want the value to just increase by
Click to expand...
1 (based on the last record in the table). How do I do this?
 
Back
Top