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

problem: table display using combo boxes, option boxes

P: n/a
I have some option boxes and combo boxes that looks up values on a
separate table (i.e. campus table with campusID & campus name fields)

When I choose a selection from the combo box, it puts the information
in a
main table when I do ADD RECORD. Only the campusID (a number) gets
added in
the main table. How can I get the corresponding value displayed on
the table (i.e. campus name) instead of the equivalent campusID (which
is unique).

I want to be able to create a subform & display the actual value the
user sees on the combo box instead of the corresponding number from
the campus table.

Main table Campus Table
========== ============
user campusID
campus name campus name

Main Form
==========
field1: User
field2 (which is a combo box that looks up the campus table): campus
name

Example:

Campus Table:
campusID campus name
========================
1 st. john
2 ucla
3 northwestern

Main Table:
User Campus name
=====================
paul 3
lisa 1
john 1
louie 2

Any ideas would be appreciated. You may email me directly at
pc*******@yahoo.com. Thank you.

Paul
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Paul wrote:
I have some option boxes and combo boxes that looks up values on a
separate table (i.e. campus table with campusID & campus name fields)

When I choose a selection from the combo box, it puts the information
in a
main table when I do ADD RECORD. Only the campusID (a number) gets
added in
the main table. How can I get the corresponding value displayed on
the table (i.e. campus name) instead of the equivalent campusID (which
is unique).

I want to be able to create a subform & display the actual value the
user sees on the combo box instead of the corresponding number from
the campus table.

Main table Campus Table
========== ============
user campusID
campus name campus name

Main Form
==========
field1: User
field2 (which is a combo box that looks up the campus table): campus
name

Example:

Campus Table:
campusID campus name
========================
1 st. john
2 ucla
3 northwestern

Main Table:
User Campus name
=====================
paul 3
lisa 1
john 1
louie 2

Any ideas would be appreciated. You may email me directly at
pc*******@yahoo.com. Thank you.

Paul


See Column. Ex: Me.ComboBoxName.Column(1)

Nov 12 '05 #2

P: n/a
Thanks it worked. How about the option boxes? How can I get it to
display the text value in the table instead of the numerical
equivalent?
Salad <oi*@vinegar.com> wrote in message news:<eZ*****************@newsread1.news.pas.earth link.net>...

See Column. Ex: Me.ComboBoxName.Column(1)

Nov 12 '05 #3

P: n/a
Paul wrote:
Thanks it worked. How about the option boxes? How can I get it to
display the text value in the table instead of the numerical
equivalent?
The numerical value in an option is associated with the checkbox. The
value displayed is in a label. So you can refer to them by referring to
the Label Name. Ex:
Select case Me.Frame0
case 1
Me.Whatever = Me.FrameLabel1.Caption
Case 2
Me.Whatever = Me.FrameLabel2.Caption
End Select

Now if I had a table with the code and I wanted to know the text value
of it, I might create a lookup table. That's just as easy.



Salad <oi*@vinegar.com> wrote in message news:<eZ*****************@newsread1.news.pas.earth link.net>...
See Column. Ex: Me.ComboBoxName.Column(1)

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.