Ok, so I am using the Northwind database as a template for my database. I am basically just using the Customers, Orders and related forms/tables. I imported all the tables, forms, modules, queries, etc from Northwind into a new db, and modified as necessary. Everything is working GREAT, (VBA code old and new, formulas, queries), but Northwind is doing something that I cant seem to get mine to do and can't figure out why!
In the Northwind database, when in the Order Details form, and trying to enter a new order for a NON-EXISTING customer (by typing in a new customer name in the customer field), it tells/asks you that the name is not in the list and would I like to add it now. When you click yes, it opens the Customers form, and the name you just typed in the order details form already appears in the First Name and Last Name fields of that form.
In my database, if I enter a NON-EXISTING customer, it asks me the same thing, and if I click yes, it opens the Customers form, but it is just blank, not entering the name as northiwind did.
The ONLY difference in the databases (surrounding this specific problem at least) is that I renamed the Company Name field in Northwind to Account Number in my database. Other than that all the field names are the same.
What I need is when I start to enter a new order, I start by entering the customers account number, and if it is not in the list, open the customers form and enter the rest of the customer info, but have the account number already there. Just as the Northwind does but with the customer name instead.
On an additional note... the message box that asks if I want to add to the list seems like an Access system message box and not a user/Northwind created function/message box.
I'd be willing to just write some new code if that will be easier than trying to debug mine, but I wouldn't know what code to write or where to put it.
In the Northwind database, when in the Order Details form, and trying to enter a new order for a NON-EXISTING customer (by typing in a new customer name in the customer field), it tells/asks you that the name is not in the list and would I like to add it now. When you click yes, it opens the Customers form, and the name you just typed in the order details form already appears in the First Name and Last Name fields of that form.
In my database, if I enter a NON-EXISTING customer, it asks me the same thing, and if I click yes, it opens the Customers form, but it is just blank, not entering the name as northiwind did.
The ONLY difference in the databases (surrounding this specific problem at least) is that I renamed the Company Name field in Northwind to Account Number in my database. Other than that all the field names are the same.
What I need is when I start to enter a new order, I start by entering the customers account number, and if it is not in the list, open the customers form and enter the rest of the customer info, but have the account number already there. Just as the Northwind does but with the customer name instead.
On an additional note... the message box that asks if I want to add to the list seems like an Access system message box and not a user/Northwind created function/message box.
I'd be willing to just write some new code if that will be easier than trying to debug mine, but I wouldn't know what code to write or where to put it.