Not sure how to do it. Can you give a little more. Here is some more info.
After the City, State, and Zip are entered for a Person in my form, I need the City, State, and Zip to also show up under that Person in a different table.
imnotsmart
Last Activity: Aug 2 '07, 05:42 PM
Joined: Jul 26 '07
Location:
-
Nevermind, I figured it out.
But I have another question. I need the info that populates in the City, State and Zip field to fill in City, State, and Zip fields in another table. Don't know if this is possible.Leave a comment:
-
Thanks!! I played with it a little and got it to work.
Now, another question. I have yes/no buttons associated with each town and a number. Is the code the same or does it change.Leave a comment:
-
The Zip is a text data type (Zip codes in NJ start with 0. If its numeric the 0 gets dropped). The table is called City. The fields are City, State, Zip. So based on what you posted before, I tried this:
Private Sub Zip_AfterUpdate ()
txtCity = DLookup("City", "tbl_City", "Zip = " & Me.txtZip)
txtState = DLookup("State" , "tbl_City", "Zip = " & Me.txtZip)...Leave a comment:
-
Yes. I have the table with all the Towns, Cities, Zips and other info I need....Leave a comment:
-
I need city and state to populate after I enter the Zip Code in Access
I have an Access DB that I'm looking to have the City, State, and some other info auto populate after I type the Zip. I am VERY VERY new to Access and am teaching myself. I don't know VB and would need to be walked through step by step. Any help would be possible.
Thanks
No activity results to display
Leave a comment: