ok guys I'm new here and some of the other threads have helped me a ton, but here's what i'm trying to do. I am making an invoice of which items are sold to a customer. I have a combobox of which the purchaser is selected and I have it to where it auto populates the address phone number ect. and thats all working finally, but now im trying to make the bottom section where i type a product number in a text box and text boxes such as item description, price ect. are auto populated, I also want to be able to pull from two different tables where the table that the price pulls from is dependant on the customer that is selected in the first part.
All help will be greatly appreciated!