General discussion

Locked

Auto-entry

By TeeKay ·
I have a table showing suburbs/towns with their associated zip/post code.
In a data entry form how do I get the correct zip/post code to be automatically entered when the user enters the suburb/town?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by G... In reply to Auto-entry

How is the table stored? File or Database? Do you use some technology like Java, ASP, PHP,...?
What is the use of your form?

If you use a database and some kind of script or program, you can then just make your program to query the database to get your information. If it's a text file you'll have to parse you text to get it.
If you want it absolutly to show up in the form you could use a javascript like like onChange(not sure it's exactly that one but that's the idea).

Collapse -

by sgt_shultz In reply to Auto-entry

since you use the terms 'table' and 'entry-form' i am guessing you are using Access?
I think if download the free Northwind sample database and Forms samples database from downloads.Microsoft.com you can just copy one that does automatic filling in of the form by looking up the data in a table. If you are using Excel, try VLOOKUP
the nw sample database is also available on the second cd of the Office Pro cd set...along with the help files for it that really explain how the stuff works

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums