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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Procedural Question - Back End forms 7
Returning part of a field value in code 1
Enter Data into a field automatically depending on data entered in previous field 3
??s Designing DB for multi users NOT on a network/server 6
Simple problem, simple answer? 6
Linking Labels on a Form 1
Can I do this with drop down lists? 2
Write Conflict Errors In Access Form (2000) 3

Back
Top