Hi there,

I'm using a combo box to select person info from a table... the combo box displays the following....
title - Firstname - Initial - Surname
.... when the user selects a particular person the person ID field in fed into another field (which is what I want)...

However, I would like the combo box display to remain (title, firstname, initial, surname) but it only displays the first column (title)... is there any way around this?

Hope you can help

Frances

Hi Frances

I understand your question, and have tried to solve the query you propose.
This page:
http://www.access-programmers.co.uk/forums/showthread.php?t=121887

gives a work around, however, I have not been able to get it to work properly. See if you can get it to work. I will need to do a bit more testing to see what the correct tweak is, but it should put you on the right path for now.

Regards

Richard

Hi, thanks for you reply... I'm not too familiar with visual basic so I got round the problem in the following way instead....

- Created combo box including all relevant columns (e.g. Combo1)

- Created 3 text boxes alongside
text 1 for firstname
text 2 for initial
text 3 for surname

then set the ControlSource properties for these combo boxes to correspond to columns in from the combo box......
=Combo1.Column(1) (2) (3) etc.

This is working fine for my purpose.