I have an order form worksheet that uses a drop down list from a named range in another worksheet, PriceList. Above the order area are some blank cells for entering the customer name, shipping address, etc. The PriceList worksheet has a data connection to an Access database.
My problem is, if the customer info section is filled out first, the drop down list of item numbers is empty. In order to fill out the form, the salesperson is having to enter all the items, save the file, then open it up again to enter the customer info. Can someone tell me why this is happening?
This the code I'm using for the item number lookup, to populate the item description and prices:
ScreenShot001.jpg
Bookmarks