This is a very interesting thread.
How about this for a question:
I have a quotation form with what could be 100 small components, labour, delivery etc.
If I get the order I want to pass the sum of the three categories (Components, labour and delivery) to an Order Confirmation Form. I don't want all 100 small parts etc. to go to the Order Confirmation form.
I do want a simple button to it though. I was planning to use a VBA append (INSERT INTO),
Is this a terrible idea (even assuming I could work out how to pass the calculated figure? Or is there a better way