dlookup results not visible on form

[Richard Wright]

Hi,

I have two different forms, both have a zipcode field with a dlookup
rountine that automatically fills in the city and state fields upon exiting
from the zipcode field. On the first form everything works fine. On the
second form the city and state fields are not updated, but if I close and
re-open the form the city and state are filled in correctly. Please help!

TIA,

Rick Wright

 

[Wayne Morgan]

Just guessing. Do the fields and their associated controls have the same
name? If so, try changing the name of the controls and when you assign the
value from the DLookup, assign it to the controls, not the fields.

Example:
If the field and textbox are named City, change the name of the textbox to
txtCity then assign the value to txtCity.

 

[Richard Wright]

Hi Wayne,

Thanks for the tip, it worked!

Rick W.