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?

 

[Bastien]

dlookup - check the help area Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Bastien]

dlookup - check the help area

run the event for this in the afterUpdate function for the zip code field

sub zipCode_AfterUpdate()
dim strCity as string
dim strState as string

strCity = Dlookup(attributes)
strState = DlookUp(attributes)

me.city.value=strCity
me.state.value=strState

End sub

roughly something like that
hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken