The problem with the code is that the"OrderID" which is a PK and an auto generated no.  doesn't

update before I run the Requery. So the initial value of the OrderID...

With this code.

Private Sub cboInvNo_AfterUpdate()

Dim ID As Integer

Dim rs As Object

Set rs = New ADODB.Recordset

Set rs = Me.Recordset.Clone

Me.Requery

ID = Me.OrderID

rs.Find "[OrderID] = " & ID

If Not rs.EOF Then

Me.Bookmark = rs.Bookmark

End...

Thanks that helps.

Is there a common way of organizing the different versions of the ADP's ?

This is how I have it now;

PurchaseOrginal.adp    Original Version

PurchaseOrder_V01272004.adp  CurrentVersion

PurchaseOrder_V01272004_Beta.adp - version that I am...