I want to use the value in a combo box to set the available options in a second combo box. How do I do this?? I tried several ways and I can get it to work the first time, but after that, it is refering to the table that stores the information and not the table where it looks the info up. I've thought about running an Append Query and a Delete Query to move the Info out of the storage table and just set it up as temporary storage but was wondering if anyone had any other ideas.

This question is asked and answered frequently. Here's a link to one I found via the search feature.
http://www.access-programmers.co.uk/ubb/Forum4/HTML/006481.html

And here's another one from today:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/006500.html

[This message has been edited by Pat Hartman (edited 04-17-2002).]