Open the orders form showing the latest customerID

J

Jerrry D

Using the Northwind database as an example I want to open the Orders form and
have it show the latest entry from the Customers table to show in the combo
box CustomerID of the Orders form. I have inserted a cmd button in the
Customers form to open the Orders form. I also added a field in the Customers
table named Date with the default value set to Now(). If someone could please
suggest the code and where to put it to make it happen I would be truly
thankfull.

Jerry
 
Top