Creating a combo box that will display relitive infromation based on another com

All, its been 7 years since I used access and I have lost
all my notes and most of my understanding so bear with
me please.

I have set up the following table

Location
person

person
item1
item2


What I want is to have a form that has a combo box to
allow me to select a location.

Depending on the location selected it will then only show
the related people to that location in another combo box

There will then be a button that opens a screen (yet to
work out how i will display this) showing

Location Person

Item1 Item2

the rest I have managed to work out but this is causing me
a major headache.

all help greatfully received.

Larry, you will find an example of cascading comboboxes here.

http://www.mvps.org/access/forms/frm0028.htm

--
Wayne Morgan
Microsoft Access MVP


"Larry" wrote in message
...
All, its been 7 years since I used access and I have lost
all my notes and most of my understanding so bear with
me please.

I have set up the following table

Location
person

person
item1
item2


What I want is to have a form that has a combo box to
allow me to select a location.

Depending on the location selected it will then only show
the related people to that location in another combo box

There will then be a button that opens a screen (yet to
work out how i will display this) showing

Location Person

Item1 Item2

the rest I have managed to work out but this is causing me
a major headache.

all help greatfully received.