Frances has attended:
Access Introduction course
Access Intermediate course
MS Access - Combo Box Display
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
RE: MS Access - Combo Box Display
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
RE: MS Access - Combo Box Display
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.
