Creation of autonumber on open form

[Pragmatic]

Hi all

I have two forms Customer and orders. There is a button on customer form which on a click opens up a orders form with corresponding customer id and orderID for which I have used the following code.

Private Sub Form_Open(Cancel As Integer)
If Not IsNull(Me.OpenArgs) Then
DoCmd.GoToRecord , , acNewRec
Me.CustomerID = Me.OpenArgs
End If
End Sub



Now what I want to achieve is that when I click on "Add order" button it should open up the order form with customerid and do create the order id until I either exit/close the order form. Can someone advise/ recommend the chages in the above code to get the required result.

Thank in advance for your reply.

[June7]

Is OrderID an Autonumber datatype field? If so, you cannot delay generating that number. It will be created as soon as any field of the new record is populated.