http://www.mvps.org/access/forms/frm0028.htm shows you how to limit the answers in a combo box based on the value in another box.
Hope that helps. Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of aecaccessnovice Sent: Saturday, March 18, 2006 9:55 AM To: [email protected] Subject: [ms_access] Zip Codes Hi, I have a very simple single table and form. I want the correct Zip Code field automatically filled (from my list of Zip Codes) when I click on the Town listed in my named Town drop down box. When I click on the town of "Wayland" in the drop down box for the Town field, I want the Zip Code field automatically filled in with "01778", or "Norwell" in the town field and "02061" automatically filled in; the classic "If, Then" function. How do I do that? Many thanks! Rodney Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
