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

My own lookups - enter one thing, table another

P: 4
Hi everyone,

I've created a table of values (LookUpSchoolNames) that I use in combo boxes on my form. The table where the data is stored is set to read LookUpSchoolNames in the appropriate fields. I have NOT used the LookUp Wizard.

My problem is that I would like the form combo box to show only the school names, but I would like the table to store the SchoolID number that I have defined in LookUpSchoolNames.

All of the instructions I've found pertain only to LookUp tables constructed in the wizard. (Bound Column, etc.) Any thoughts? Thanks!!!
Oct 19 '06 #1

✓ answered by NeoPa

In the ComboBox, set two columns - ID & Name.
Set Bound Column to the one to be accessed (probably ID) but in the column widths, set the width of the one you don't want to show to zero.
Column widths are separated by ';' so in a 5cm ComboBox the ColumnWidths would be "0cm;5cm".

Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,471
In the ComboBox, set two columns - ID & Name.
Set Bound Column to the one to be accessed (probably ID) but in the column widths, set the width of the one you don't want to show to zero.
Column widths are separated by ';' so in a 5cm ComboBox the ColumnWidths would be "0cm;5cm".
Oct 19 '06 #2

P: 4
Perfect! Thank you. That was much easier than I would have thought.
Oct 19 '06 #3

Post your reply

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