Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

René said:
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
Click to expand...
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
Click to expand...
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
Click to expand...
which would pull up the individual
 
Back
Top