There are many ways to accomplish what you want, but most of them involve a knowledge of things like combo boxes or simple event procedures. As you are a "newbie", you may not feel comfortable with these. To do what you require in the simplest, though not most elegant way, requires two queries...