RE: this is a tough question about combo boxes

I am trying to relate this to Access 97 and I am a fairly new at this.
another question i have is when I dont bound my textbox it fills down
everything instead of one line and a bound textbox I cant select anything?

"esparzaone" wrote:

> I am setting up a perpetual inventory system. I have set up a form for my
> purchase orders and created a subform from my transaction table. Here is my
> question - I have 3 combo boxes. 1 - account 2- product name 3 - product
> description I want to base what account number I pick from the drop down
> selection in combo box 1, I want combo box 2 to only list the products that
> are associated with that account and then whatever is selected from combo
> box 2 to automatically fill in combo box 3 with combo box 2 description. I
> am relatively new so I would need plain english. I have tried to use "how to
> synchronize 2 combo boxes on a form" I had problems because every time I went
> into the form it asked me for the parameter and I am using this to order
> multiple items are not from the same account. PLEASE HELP!!!!!!
.