Creating filtered forms

[Jennifer]

I have a customer form and a orders form. on the customers form I created a
button that will filter the information by CustomerID. when I open the orders
form It is okay for the first order. but when I have switched to a new
customer then open the orders form it does not save anything to the orders
table. When I go back to relook at the orders form the information is gone!
How can I correct this? Can I correct this? Help!!!!!

 

[John W. Vinson]

I have a customer form and a orders form. on the customers form I created a
button that will filter the information by CustomerID. when I open the orders
form It is okay for the first order. but when I have switched to a new
customer then open the orders form it does not save anything to the orders
table. When I go back to relook at the orders form the information is gone!
How can I correct this? Can I correct this? Help!!!!!

Correct the error in your code. If you would like help doing so... post the
command button code so we can see it.

Normally one would use a Form based on Customers with a Subform based on
Orders... are you intentionally choosing to do it the hard way?