Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autofill the city and state fields

Status
Not open for further replies.
keelerobert

keelerobert

Technical User
Joined
Aug 2, 2005
Messages
17
How can i use the ZipCode field to autofill the city and state fields on a form? I have a table called City that has fields for ZipCode, City, and State. The ZipCode field is related to the CompanyZip field in the Company table.
 
Sort by date Sort by votes
Have a look on DLookup Method
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question Question
Getting the Monday date from a week number
Replies
2
Views
1K
TomSalvato
TomSalvato
breezett93
  • Locked
  • Question Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
2K
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
This is the source query for what
Replies
12
Views
929
dhookom
dhookom
BlakeLacy1
  • Locked
  • Question Question
COPY ALL FOLDERS AND CONTENTS TO A NEW LOCATION
Replies
4
Views
532
Andrzejek
Andrzejek
Kim296
  • Locked
  • Question Question
FILTER SUBFORM USING MAIN FORM FIELDS- VBA
Replies
8
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top