My "Customer Details" form is asking me the value of CustomerID when i'm closing it...
(after closing this form the program goes to the main menu form which has no data).
What is the record source of your customer detail form? I'm guessing it's a query that needs to have a customer ID assigned to each record, and that the customer ID is a foreign key in your customer detail table.