Solved

Access 2007 How to change a form that updates a table

Posted on 2011-09-21
2
203 Views
Last Modified: 2012-05-12
I'm new to access, so this question is probably simple.  I'm looking at a db someone else created.  It has table "location" containing ID (autogen'd), and location name(text). There is a form that creates/updates records in another table - let's call it "targetA".  This form contains a dropdown allowing users to pick a location.  The user picks a location name (text), and the corresponding ID number is posted to targetA.  Where/how do I change it so the location name gets posted to targetA instead of the ID?
0
Comment
Question by:Scarlett20
2 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 250 total points
ID: 36577215
Instead of posting the location name to targetA, just post the ID.  That is proper technique for a normalized database.  You can display the name on the form (and elsewhere) using the linking field.
0
 

Author Closing Comment

by:Scarlett20
ID: 36930925
Helen - thanks so much!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question