this is a tough question about combo boxes

[Guest]

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!!!!!!

 

[Ken Snell [MVP]]

This article tells you how to tie the two combo boxes together:
http://www.mvps.org/access/forms/frm0028.htm

This article tells you how to show the other columns of a combo box in
textboxes:
http://www.mvps.org/access/forms/frm0058.htm

 

[Guest]

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?

 

[Ken Snell [MVP]]

I'm sorry.. I am not understanding what you're asking here. Can you please
describe in more detail what you are seeing and what you want to happen?
Textboxes don't "fill down"?

 

[Guest]

actually it was the operator... I got it to work! Thank you for the sites
they are very useful.