Bill - you DON'T want to.
The whole point about RELATIONAL databases is that you store the
reference to the record in the Contacts table rather than the
contents of the record in the Contacts table.
Your combo box is doing exactly what it should.
If you then want to display the data from the Contacts table on a Form or Report you can do that by :-
( for 'Form' below read 'Form or Report' )
Have a control on the form bound to the field containing the contact reference ( ContactRef )
Make this control hidden ( .Visible = No )
Then have a text box control with a ControlSource of:-
=DLookUp("NameField","Contacts","ContactId = ContactRef"
As DLookups take ( relativly ) quite a long time, if you need more than one DLookup from any given table on a form then you should use a Recordset inside the form's On_Current event ( On_Format in a Report ) and set the text box contents from the returned values.
'ope-that-'elps.
G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.
Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D