if your zipcode is part of your town drop down then you can do an afterupdate event on your town field and set the zipcode to equal the zipcode on the combo box.
For example Dropdown = Town, Zip set the event to equal me![Zip] = Me![town].column(2) Hope this helps Thanks Eileen --- In ms_access@yahoogroups.com, "Crosier, Dawn" <[EMAIL PROTECTED]> wrote: > > 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On > Behalf Of aecaccessnovice > Sent: Saturday, March 18, 2006 9:55 AM > To: ms_access@yahoogroups.com > 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/
