Have a basic sales database in Acess. When entering a sale on a datasheet form I have a combo box that is populated by all products in the products table. I want it to only include items that are not deleted (Yes/No checkbox in table) for new sales but still have deleted products show up when viewing/researching old sales. Can only figure out how to do one or the other, but not both. Any ideas?
