combo filter

[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

 

[cecild]

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

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