Updating table with changes in form

[gemadan96]

I have started with the Desktop Contacts database template for Access 2010.



In the Members table I've added a lookup field for Rank which gets its values from the Rank table. This field has been added to the Member Details form. I've added a control with a DLookup function that looks up the selected Rank and returns the correct Title for the member. When I save the form I want it to update the Title field in the Members table. At the moment it is not doing that. The control in the Member Detail form is named Title and the field in the Members table is also named Title.

The Title does need to be stored in the Members table for other features and it will change as the member's rank changes.

How do I get my table to update as data in the form changes?

[Missinglinq]

Here's an explanation of why Lookup Fields at the Table level are a bad idea:

http://www.mvps.org/access/lookupfields.htm

Instead, create a Combobox in your Form based on the Table holding the data you want to retrieve.

Linq ;0)>

[gemadan96]

Let me correct what I have. Rank is not a lookup field in the Members table. Rank is a combobox on the Member Details form. When the Rank is selected on the Member Details form the Title control uses a DLookup to fill in the correct title from the Rank table. When the form data is saved the correct Rank is entered in the Rank field of the Members table, however the Title is not being updated. I want the Title to be updated.