Combo box

[René]

I've been given a request from my marketer and I am not sure how to accomodate her

On our sales inquiry form, I have a combo box from which you can choose the company from which the referral came. What my marketer would like to know is who the specific individual was that made the referral.

She would like to have the combo box which lists the company name then open further to include the names of the individuals in the company and have that information saved on the sales inquiry form so that it can be queried or reported at quarter end

Her ultimate request would be that the company would pull up a location which would pull up the individual

Ifyou can help with this it would be greatly appreciated

 

[Ken Snell]

You could do this using two combo boxes on the form, where the second combo
box is filtered based on the value chosen in the first combo box. Thus, when
the user selects a company in the first combo box, the second combo box
would display only the employees associated with that company.

See The Access Web for an example of how to do this:
http://www.mvps.org/access/forms/frm0028.htm



--
Ken Snell
<MS ACCESS MVP>

I've been given a request from my marketer and I am not sure how to accomodate her

On our sales inquiry form, I have a combo box from which you can choose

the company from which the referral came. What my marketer would like to
know is who the specific individual was that made the referral.

She would like to have the combo box which lists the company name then

open further to include the names of the individuals in the company and
have that information saved on the sales inquiry form so that it can be
queried or reported at quarter end

Her ultimate request would be that the company would pull up a location

which would pull up the individual