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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form #1 that filters form #2 6
Using Access 2003 3
adding records to an order form 6
How do I create mutiple orders in a subform linked to Customer ID? 2
adding records to a form need a code or how to 1
Combo box to display something else if field is blank 1
Open Form and GoToNew with an ID from the first form 1
totaling in a filtered form 2

Top