G Guest Nov 10, 2003 #1 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?
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?
D Dan Artuso Nov 10, 2003 #2 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?
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?
