473,240 Members | 1,633 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,240 software developers and data experts.

problem: table display using combo boxes, option boxes

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
3 1960
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Paul | last post by:
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...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
1
by: D Perron | last post by:
I am having a problem working with one combo box that is filtering another combo box. My table is tblResearch. There are two field in this table; one is and the other . I have a form called...
6
by: Ron L | last post by:
I have a dataset whose source is a SQL 2k stored procedure that I am trying to display in a datagrid. This datasource has 4 columns that I am interested in here, a text column and 3 value columns...
6
by: visionstate | last post by:
Hi there, I am building a database that requires cascading lists on a form. I currently have (I may be adding more later) 3 combo boxes on my form - Department, Surname and Forename. The user...
4
by: Kev | last post by:
Hello, I have an Access 2003 database running on an XP network. I have a datasheet subform containing a 28 day roster - shift1 to shift28. Each record has 1 RosterEmpID, 1 EmployeeNumber, 28...
3
by: prakashsurya | last post by:
Hi i am having a small problem with combo boxes actually i am preparing a form in which i have to go through the experience in years for that i am using 4 combo boxes. on the first two combo...
2
by: biganthony via AccessMonster.com | last post by:
Hi, I decided to install Office 2003 Service Pack 3 on my home computer to test (in full knowledge that there may be some issues with it). After installation, I have noticed that with a small...
4
by: Gilberto | last post by:
Hello, I have a couple of forms using the code to FIND AS YOU TYPE from Allen Browne (http://allenbrowne.com/AppFindAsUType.html). It worked PERFECTLY until yesterday when i splitted the db into...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.