Recent content by mjnov85

Hello, I am making a database where ppl can input customer orders and other's can then commit to that order, the order number is my primary key for both of the following tables. So i have a table with OPN1, OPN2,...... OPN12. Each one of those fields has a corrosponding quantity1...

Thanks for the information Uncle Gizmo. I was wondering if you know any resource on how to do what you are telling me to do, because i dont really know how to code that well in VBA and it would be nice to have a template to base my code off of. Once again thanks for all the help!!!

Unfortunately i have to physically remove that information from that order. It must be deleted and put on the tblHistory. This is because i do not want these parts to be ordered later on in the process. If i just didnt want them to be displayed it wouldnt be a big deal, but i must have it so it...

Ok so here is my problem. I have a subform that I use to capture upto 6 different items that a user can order within 1 customer order (this is the main form). Now I would like to have the user be able to come back to the form and "cancel" any 1 item off of a certain order number. I would like...

Thank you very much. Your suggestions reallly helped and led me to cascading combo boxes. :)

I am designing an order form and my order form consist of a main form and a subform within it. Each order can have multiple items ordered on it. To order a certain part (unique model #) i have a query set up that inputs 1 model number when 4 other variables are chosen in a combo box by the...