I have a form that is used for entering and editing site address
information. The data in the form is from one table, named
Total_Site_Address. There are fields in this table (and controls on
the form) for entering in a new site address or choosing an existing
site address. There are two fields that address the existing site
addresses, one named ADDRESS, the other named TAX_NAME (contains
municipality info). The ADDRESS field is setup as a lookup and it
pulls the site address data from a query. This query, named
SiteAddress-Existing, pulls data from two linked tables. In the
SiteAddress-Existing query, there are two fields named SITE_ADD and
TAX_NAME. The Lookup values for the ADDRESS field are from the
SITE_ADD field in the SiteAddress-Existing query.
I would like to be able to automatically update the TAX_NAME field in
the Total_Site_Address table based on the ADDRESS field. In the form,
there is a control that allows the user to choose a site address from
from a combo box. When this address is chosen, I would like the
TAX_NAME field in the Total_Site_Address table (and the control in the
form) to automatically update with the municipality that the chosen
address exists in.
An example of this is if a user chooses from the combo box "123 Jones
Road", with a corresponding Tax_Name in the SiteAddress-Existing query
of "Town of Johnson", I would want the "Town of Johnson" to be stored
in the TAX_NAME field in the Total_Site_Address table, automatically.
The TAX_NAME field in the Total_Site_Address table is a Text field,
and the control on the form which displays the TAX_NAME is just for
display, not data entry.
Thanks for any advice. 1 2019
It's not clear what you're driving at. You want to create a combo box which
looks up a town based on a street address? So the user selects "1600
Pennsylvania N.W." (the address of the White House) and it returns
"Washington, D.C."? (Not so unusual.)
Robert
P.S. Post table layouts
"Jason" <JA********@CO.COLUMBIA.WI.US> wrote in message
news:f0**************************@posting.google.c om... I have a form that is used for entering and editing site address information. The data in the form is from one table, named Total_Site_Address. There are fields in this table (and controls on the form) for entering in a new site address or choosing an existing site address. There are two fields that address the existing site addresses, one named ADDRESS, the other named TAX_NAME (contains municipality info). The ADDRESS field is setup as a lookup and it pulls the site address data from a query. This query, named SiteAddress-Existing, pulls data from two linked tables. In the SiteAddress-Existing query, there are two fields named SITE_ADD and TAX_NAME. The Lookup values for the ADDRESS field are from the SITE_ADD field in the SiteAddress-Existing query.
I would like to be able to automatically update the TAX_NAME field in the Total_Site_Address table based on the ADDRESS field. In the form, there is a control that allows the user to choose a site address from from a combo box. When this address is chosen, I would like the TAX_NAME field in the Total_Site_Address table (and the control in the form) to automatically update with the municipality that the chosen address exists in.
An example of this is if a user chooses from the combo box "123 Jones Road", with a corresponding Tax_Name in the SiteAddress-Existing query of "Town of Johnson", I would want the "Town of Johnson" to be stored in the TAX_NAME field in the Total_Site_Address table, automatically.
The TAX_NAME field in the Total_Site_Address table is a Text field, and the control on the form which displays the TAX_NAME is just for display, not data entry.
Thanks for any advice. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Drew |
last post by:
I have a db table like the following,
UID, int auto-increment
RegNo
Person
Relation
YearsKnown
Now here is some sample data from this table,
|
by: cloverme |
last post by:
Hi,
I need help populating a listbox from a database on a webform.
I created a an access database with a table, fields and data. Then I
created a WebForm in vb.net and added a DropDownList...
|
by: Lumpierbritches |
last post by:
Thank you once again for any and all assistance. I'm building an application
that's getting quite bulky due to the number of forms, macros and procedures. I
was wondering if there's a way to use 1...
|
by: EJH |
last post by:
I have a Database that has three tables. One of the three is just a table
that contains three fields and is filled with reference information. One
field is 3-Digit(primary key), the next is...
|
by: Patrick |
last post by:
Am upgrading an application from VB6 to VB.Net. One of the controls is a ListView that am failing to populate. Am including some of the code for some assistance where I may be going wrong.
Private...
|
by: Mary |
last post by:
I'll pulling my hair out on this one and would be so appreciative of
any help.
I am creating a data entry form to enter results of a student survey.
There are 40 questions on the survey. The...
|
by: wideasleep |
last post by:
Hello,
I have a form that has a combo box that populates other fields. This works great but it doesn't save that information in the table where those fields are coming from. The only one that's...
|
by: prosad |
last post by:
hello,
Just solved a problem using Javascript onclick, can click on any cell in a dynamic table and it will pass the innerText object value to my form text field. parts of code given below:
...
|
by: daverskully |
last post by:
I have two tables created and want to link two forms created from these tables so that specific fields are populated once one field is selected, but not all fields being populated, with a new record...
|
by: daverskully |
last post by:
I have two tables created and want to link two forms created from these tables so that specific fields are populated once one field is selected, but not all fields being populated, with a new record...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |