I want multiple fields on a form to populate based on a single entry. For example: if I type in a zip code in 1 field, I want City & State to auto-populate in 2 other fields on the same form.

I also want to the city & State info to be saved in the data table.

Is this possible? If so, how.

I've been working with Dlookup but can't seem to get it to populate. It finds the information for me just fine when I'm in debug mode.