By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,314 Members | 1,539 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,314 IT Pros & Developers. It's quick & easy.

Look up ms access 2003

P: 4
I have a table with three fields in it which have a combo box lookup. I have then created a form with various fields on it but want the three drop down lookup's to display all three under one column. i.e. lookup's are Order, Forname and Surname. On the form I have selected Order and from that want all three to appear under that column. Can it be done?
Thanks
Dec 2 '11 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 446
Hi Phil,
I find your explanation a little unclear but I think you are asking whether a combo box can open and show three columns.

The answer is Yes, but you must base the combo box on a query that returns the three columns. This is set in the RowSource of the combo. You will then have to set the Column Count to 3 on the Format tab and then set the Column Widths property to something like '2;2;2cms', then finally set Width to 6cms.

This should get you started. Have fun!

S7
Dec 2 '11 #2

NeoPa
Expert Mod 15k+
P: 31,707
As S7 says, you certainly can have multiple columns in ListBox and ComboBox controls. Only one column can be treated as the value of the control though (but the others are all accessible in VBA via the Columns() property of the control).
Dec 3 '11 #3

100+
P: 759
Hi,

If you wish to see all three field at the same time, under a single combo box, (As S7 and NeoPa assum) I can't understand the logic to use a combo box for that. You can't use this combo box to make three choices. (See #3 - NeoPa).
So, I think that a better way is to use a list box (based on a query as S7 suggest). You can modify the height of list box to show only one row (or two if you set Column Headers to true).

But maybe what assume S7 and NeoPa is wrong and this is only a layout problem.
So, if you wish to show your combo boxes on the same layout column, just move a combo box under the other one by dragging it with your mouse.
Dec 3 '11 #4

Expert 100+
P: 446
Mihail,
Having additional columns in a combo box that only display when the combo is expanded, can be very useful.

If searching for an Order, it is sometime useful to have the customer/client name alongside and pick it out of a combo list. The OP seems to want to use Forename and Surname to differentiate the Orders.

Obviously, if you are certain of an Order Number then a text box is the more efficient way to search, because it does not have the overhead of holding a link to every order on the system.
S7
Dec 4 '11 #5

TheSmileyCoder
Expert Mod 100+
P: 2,321
Create 2 combobox beneath your existing combobox. Give them the same rowsource, columncount, and bind them to the same field as the original combobox. Now in the 1st of teh new comboboxes, you specify the column width to be 0;3cm;0 (or inches or whatever), and the 2nd of the new combo to have columnwidths 0;0;3m
This means that the forname will be shown in 1 combobox and the lastname shown in the other. Not to confuse the user, I would disable the 2 new combobox, and give them another backcolor, to show to the user they are different (not interactable).
Dec 5 '11 #6

Post your reply

Sign in to post your reply or Sign up for a free account.