INSERT INTO Orders ( StartDate, User_ID, Company_ID, Country, ShipCountry) VALUES ( #CreateODBCDateTime(Now())#, #User_ID#, #CID#, 211, 211) SELECT Max(Order_ID) As MaxOrderID FROM Orders SELECT Orders.* FROM Orders WHERE Orders.User_ID = #User.User_ID# AND Orders.Orderdate Is Null AND Orders.Order_ID = #FindNewID.MaxOrderID# AND Orders.Company_ID = #CID#