How do I fill in multiple fields?

[walkert]

I would like to fill in the "City" and "State" fields when I put in the zipcode. I have a table created with the zipcodes in it. (3 fields,zip,city,st.)

How do I make it fill in?

 

[mtomar]

How many tables you have in your database file?

If it is one table I think you can't do it.

But if you created two tables like: tbBASE & tbMOVMENT
and zipcode is primery key in tbBASE and many in tbMOVMENT
it is possible to get what you want.

mtomar@msn.com

 

[jitter]

Maybe on the lost_focus, after_update or exit event of the zip code you could use the DLookup Function.



Private Sub Zipcode_AfterUpdate()
txtCity.Text = DLookup("[City]","tblZip","[ZipCode] = '" & txtzipcode.text & "'"
txtState.Text = DLookup("[State]","tblZip","[ZipCode] = '" & txtzipcode.text & "'"
End Sub


I did not run this but I think this might be what you want.