How to alter table not in form

[Knutjo]

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)

 

[farrah]

Well I am also new to this..but can't u have an update query to increment the order number by 1 (on systable) each time u enter a new order?

 

[Rich]

You have to use DMax +1 go to Candace Tripp's site there's an example there.
HTH