combo filter

  • Thread starter Thread starter Squibbly
  • Start date Start date
S

Squibbly

i got a problem, is that i cant seem to find the correct answer to a form

what i want to do is use a combo box on a form that allows me to filter
names from different companies:

i have searched the internet, googled it and still no answer for it how do i
go about it?
what i want to do is select the company name like for e.g. Tesco, then that
will display on a form the person's name and department
 
Squibbly said:
i got a problem, is that i cant seem to find the correct answer to a form

what i want to do is use a combo box on a form that allows me to filter
names from different companies:

i have searched the internet, googled it and still no answer for it how do
i go about it?
what i want to do is select the company name like for e.g. Tesco, then
that will display on a form the person's name and department
Click to expand...
If I understand your question, this should work.

Create a list box that will take the company selection from your combo box
as the filter. In the on update event in your combo box add the following
expression ( LISTBOX NAME.Requery ). This should in return give you a
list of people in that company. Create your list box with the columns of
data that you want to see ie... person's name and department.

Hope this helps,

Cecil
 
Back
Top