Simple form lookup question

[Peter C.]

I've done some searching but can't seem to find an answer to my
seemingly simple question.

In Access2002 I'm creating a form. One item is a list box which pulls
from table2. I want to make list/combo box after that one that will
pull info from one of two tables, table3 or table4, depending what is
picked in the first list box.
So if I pick from the list box "table4" I will get a list of things in
the next list box that were pulled directly, and only, from table4.

Make sense?
When you're done laughing at how easy this is and I overlooked it,
please let me know how it's done.

thanks
pwc

 

[Dawn]

PWC: Here is a URL to an article called How to Create
Synchronized Combo Boxes, Article 98660. Sounds like this
is what you are looking for. I have done some research on
this but have not actually tried it. Hope it works for
you.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;98660