Refreshing the form and Automatic saving question

[goldmedallist]

Dear all

My inquiries is 2 fold

1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form.

In more elaborate terms, I have a Main Client Form, and a Fee tracking subform. Each Client can have more than one account, so in the Fee tracking subform, I have a account combo box that provides the value that correspond to the client on the main form based on a query i generated.

>> My question is everytime i scroll through the clients, I still get the same drop down values for the previous client. I installed a refresh command button and upon clicking that, it gives me the new account numbers that correspond to the current client upon. What I would like to ask is if there is any simpler or automatic way of refreshing?

2) I am not that familiar with how Access records the data in the underlying tables, but right now, all the changes I make is recorded. Is there anyway to do so such that changes will be saved only upon the user confirmation and not automatically?

Thanks a lot in advance on any advice

Regards
TK