Hey!
Since I'm very new to Access/VBA I need some help to solve a little problem (I hope).
I'm working on a form, which is a typical "order" and "order details" form. The form shows data from det "Order"-table and the "Orderdet"-table.
When I create a new order I want to get the "next ordernumber" form the "Systable". I also want to increment the "next ordernumber" in the "systable" and update "Systable" in the background when I'm creating the new order. Can anyone give an example of how the code should look ??
(I have been looking into some examples , but haven't found any solution)
(The Autonumber function is not Good enough. We want to maintain those "next numbers" in a "Systable"-form)
Since I'm very new to Access/VBA I need some help to solve a little problem (I hope).
I'm working on a form, which is a typical "order" and "order details" form. The form shows data from det "Order"-table and the "Orderdet"-table.
When I create a new order I want to get the "next ordernumber" form the "Systable". I also want to increment the "next ordernumber" in the "systable" and update "Systable" in the background when I'm creating the new order. Can anyone give an example of how the code should look ??
(I have been looking into some examples , but haven't found any solution)
(The Autonumber function is not Good enough. We want to maintain those "next numbers" in a "Systable"-form)
