Combo box info not staying on form

[KatieK]

I created a form with 3 combo boxes. The first is for Distributors and in Design mode, it shows Unbound. The second and third are cascading, the first is Company and the second is Theatre. In the Theatre, in Design mode, it shows Unbound also. When I populate these forms and scroll back to the previous forms, the info in the Distributor and the Theatre fields are gone. How to I get these fields to save the information when I enter it into the form? I guess, how do I make the unbound fields bound?

 

[KatieK]

When I try and "bind" to controlsource, it doesn't allow me to enter info in the field on the form. I have attached my db, would you mind taking a look and seeing if I'm doing this right. I need to be able to input some info in the form and then at a later date, go back and input payment info. Then print out some kind of invoice or report to reflect balances owed.

My query seems to do the trick for calculating but the form is giving me trouble. When I open the form, it seems to clear all the previously input info and continuously take me to Record 1.
I really appreciate all your help.

 

[billyr]

I looked at your db. The 3 cbos on your form were not bound to their respective fields. They are now (see attached).
Observations/hints:
I would not use spaces, special characters, or punctuation in the name of any object (tables, forms, queries, controls, etc).
I would suggest you add an ID field to all your tables. You are reserving space for 50 characters each for each record for your distributor, theatre, and company fields. You can just as easily DISPLAY the names, but store only the respective IDs in tblAll.