dlookup results not visible on form

  • Thread starter Thread starter Richard Wright
  • Start date Start date
R

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
 
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.
 
Back
Top