automatic insert for linked fields ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set Access to automatically insert a postal code when the
town name is entered ? They are only town postal codes, i.e. 29719 covers the
town of Velez Malaga, 29713 covers Los Romanes etc..
 
yes, if you have a table with town names and their postal codes - you can
either use combobox or textbox to enter town, and then either read postal
code from combo other column or use DLookup() function to get it from table
directly
 
Back
Top