473,574 Members | 2,749 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Display different value in Combo Box

I have a combo box which contains a list of JobStatus's which are paired,
"Descriptio n" (a string to display) and "StatID" (an Int to store). These
come from my JobStatus table.

I have a screen for updating Jobs, on it I want to have a combo box to
represent the Job.JobStatus field, which will reposition the Combo Box to
display the corresponding Status that is assigned to that Job, and then of
course the user can pick a new status from the list provided. So the value
being stored in the Job.JobStatus field corresponds to the JobStatus.StatI D
field, but when viewed in my app I want to display the JobStatus.Descr iption
field instead of the int value. How can I do this?

Originally I had just a textbox which had a databinding to the Job.JobStatus
field, but I dont see how I can bind it to this field, and display a
corresponding description field from another table??

Any advice would be a great help.

Thanks

Jul 21 '05 #1
0 997

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
1518
by: scott | last post by:
I'm trying to display a small "color square" to the left of each combo box choice. I know I can make each choice have a different background color, but is it possible to display a background image for each row? In my code below, I'm trying to display img_color1.gif which is a 5 pixel wide by 10 pixel high transparent gif with a small color...
2
10594
by: Brian | last post by:
Hope you all had a great holiday. I have a subform with a table with a combo box based on a select query. The combo box is set to display in a form in datasheet view. When I click the down arrow I can see all of the columns in the combo box but it only shows one column after selecting it. I would like all of the columns to display when...
2
3000
by: Dave N | last post by:
I have a combo box that displays the names of all the users in my "Users" table. I set the RowSource to a Query from the "User" and "Project" tables. I can select any name from the list and that name comes up in the combo box on the form. Everything works fine this way I just want to automatically put the user name in the combo box display....
0
766
by: Steve | last post by:
I have a combo box which contains a list of JobStatus's which are paired, "Description" (a string to display) and "StatID" (an Int to store). These come from my JobStatus table. I have a screen for updating Jobs, on it I want to have a combo box to represent the Job.JobStatus field, which will reposition the Combo Box to display the...
3
2225
by: BrianDH | last post by:
Hi Is there a way to have the view/display width different from the width as it sits on the form?
3
3944
by: BrianDH | last post by:
Hi Is there a way to have the view/display width different from the width as it sits on the form? Thanks Brian
7
2833
by: luanhoxung | last post by:
hi all!! i get small trouble in display a text box. My text box will be show a value string base on my combo box choice. But text box always get the same value when i choose a new value in combo box. ex: combo box---text box AA 123<--change 456<--change 789 BB 456 <--change 789 CC 789
10
7227
by: thh108688 | last post by:
Hi all, I have got a question here perhaps someone can provide me some good information or suggestion. In the Access Form I have created 2 combo box one is Activity combo box, the other is Condition combo box. When i select on Activity combo box value, my Condition combo box will display all the descriptions of the Condition corresponding...
8
2874
by: ardhuru | last post by:
Hello, I am a complete newbie with VB, so this question might sound really stupid; please bear with me. My question is, can a combo box be used to display a value in the sense a label can? I have developed a piece of hardware (PIC based) that I have connected to the PC over the serial port. Now, I get time from the PIC in an HH:MM format,...
0
7736
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8066
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8249
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7826
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8106
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6461
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5631
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5305
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3743
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

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.