Oct 8 2007, 11:41 AM
I have a combo box on a form where the column headings are set to Yes. Is there a way placing any code which would allow different column headings to appear e.g. DrCode becomes Consultant ID, etc.
DrCode is of course the name of the field in the table. This and other field names come from a Oracle table to which I have no control over.
Oct 8 2007, 11:54 AM
I would suggest to set your RowSource to a SQL Statement and use ALIASES as your Field names ...
SELECT DrCode As [Consultant ID] FROM tblMyTable
Then you column heads will show "Consultant ID" and not DrCode.
Oct 8 2007, 11:55 AM
Do this in the RowSource of the combo box itself: instead of just selecting DrCode as the field in a particular column, use: Consultant ID: DrCode
Oct 9 2007, 03:57 AM
Oct 9 2007, 01:17 PM
You are welcome!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here