Unexpected Data Retrival in Form

[jcbhydro]

I have an entry Form which is used to record prospective new members of a society in a Table named 'Foreigners' in a Membership Database using Access 2010. The entry form also records the name of the 'Interest Group' to which the prospective member is initially affilliated
On entering this Group Name, selected from a drop down list from the Groups Table, The Group ID & Leader Member ID are automatically recorded.
However, I don't wish to record the Leader Member ID, what I wish to record is the Leader's Member Name which is identified by that ID in the related 'Mail List' Table.

In the Properties sheet the relevant source for this field is shown as Leader, but what is displayed is the Leader ID.

Any suggestions would be very welcome.

jcbhydro

 

[Uncle Gizmo]

Whats wrong with using the ID?

You can find the text associated with the ID easily, and you are also following the normal way MS Access databases should be constructed.

 

[jcbhydro]

Thank you for your comment.

My point is that the form is requesting the display of the Leader'MemberName' but it is the ID which is displayed.

jcbhydro

 

[Mile-O]

Use queries for your forms and controls; never tables.

 

[jcbhydro]

Uncle Gizmo,

I would be grateful if you would amplify on your statement that the 'text of the associated Member name can easily be obtained'. This easy routine is not entirely obvious to me.
I am still puzzled as to why a form field calling for a 'Leader name' displays a 'Member ID'.

Regards,

jcbhydro

 

[Uncle Gizmo]

I create videos which I post on YouTube. This one below answers your question. Have a look in the video from 1 minute in, it shows you how to set up a combobox.

Excel to Access Part 4: http://youtu.be/mm0PoiJUZ9E