How do I limit the data in a drop down box in a form in access?

[Craig Hales]

I have a form with a drop down box that is linked to my contacts table. I want to only show certain contacts as some are old and dont want to be seen. How do I only show the current ones in the drop down box?

[mshmyob]

You change the RowSource query to include the filter you want (ie: use a WHERE clause in your SQL Select statement).

cheers,