Form Functionality

[jahoff3]

I have created a form that contains the following combo boxes: Territory,
Broker, Account Status. The form is a tool for our sales group to use to
identify the correct people working on certain accounts. What I would like
to happen is the following: the sales rep opens the form and selects a
territory. From there, the Broker combo box is populated with brokers tied
to the selected territory. From there, the status box is populated with
status options tied to the selected broker. Finally, the designated
collector information populates into a text box telling the sales rep who to
contact. I only know the basics of Access, so any help I can get will be
great.

 

[Golfinray]

First, I would look at Martin Greene's site at www.fontstuff.com and Allen
Browne's site at www. allenbrowne.com. Both excellent examples of multiple
search forms, which is what it sounds like you need.

 

[jahoff3]

I took a look at the two sites, but need more help. Like I said, I only have
basic level knowledge of Access. Any chance I could get step-by-step
instructions on what I need to do?

First, I would look at Martin Greene's site at www.fontstuff.com and Allen
Browne's site at www. allenbrowne.com. Both excellent examples of multiple
search forms, which is what it sounds like you need.

I have created a form that contains the following combo boxes: Territory,
Broker, Account Status. The form is a tool for our sales group to use to

[quoted text clipped - 6 lines]

contact. I only know the basics of Access, so any help I can get will be
great.