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

Display values in a combobox frm a table

P: 5
Hello,

More questions from this newbie:

I have an Application table which has Application ID and Application Name. I have another table Variable which has Variable ID, Application ID and other columns.

I have a form with a dropdown list which should display the Application Names in the dropdown list. A criteria for the name to be displayed is that it should already have a record in the Variable table.

I am able to display dropdown values in the form but it displays the Application ID. What should I do to be able to display the Application Name and not the ID.

help!!!

thanks,
lyanne
Mar 4 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hello,

More questions from this newbie:

I have an Application table which has Application ID and Application Name. I have another table Variable which has Variable ID, Application ID and other columns.

I have a form with a dropdown list which should display the Application Names in the dropdown list. A criteria for the name to be displayed is that it should already have a record in the Variable table.

I am able to display dropdown values in the form but it displays the Application ID. What should I do to be able to display the Application Name and not the ID.

help!!!

thanks,
lyanne
Hi Lyanne. In your combo box properties you will find the column widths property. If you have two columns in the combo it will show two values, like this:

1.667cm;4.524cm (exemplars only)

It is normally the case that the first column is the 'bound' column, the one which displays the ID value. If you set the width of this column to 0 it will show the other column - the Application Name - instead of the ID. To do this, just change the widths like this:

0cm;4.524cm; (remember to use your own column width, not mine!)

Then reduce the list width property to reflect the narrower list.

-Stewart
Mar 4 '08 #2

Post your reply

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