Lookup values for display on a form
Posted on 2004-11-07
Need a little help. This should be pretty simple.
I have a form that has a combo box "name" derived from table "people" and stores the primary key "personID"
I want to display below the name combo box the corresponding address, phone, city, state and zip fields from the table people. I do not need to store the corresponding data in any additional location.
I assume i want to do something in the afterupdate of the frm field "name"
I suspect it could set values on the form to equal the appropriate values from the other table.