Access 2007 How to change a form that updates a table
Posted on 2011-09-21
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?