473,288 Members | 1,794 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,288 software developers and data experts.

Combo Box final format in form

2
Hi, I have created a combo box with 3 columns , one (key) is hidden and 2 columns are appear in selection part of combo : first_name and last_name .
Both first_name and last name are appear in opened list of combo.
When the proper pair is choosen , the final value shown in combo box is a first_name only ...
How I can make the final value shown in form to be in same format as I selecting it : first_name:last_name
May 31 '10 #1
1 1017
OldBirdman
675 512MB
Short Answer - You can't.

If this combobox were bound to a field in a table, then if you selected a Last-First name combination and could display it in the text portion of the combobox, you would change the table to Last-First for the bound column. This would not make sense.
However, this combobox is probably not bound, You could fake it, and make what you want apparently possible.
Simplest solution might be to assign strFirst & " " & strLast into a textbox or label elsewhere on the form. User would become accostomed to looking at this display for verification of results.
May 31 '10 #2

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

Similar topics

2
by: Wolfgang Kreuzer | last post by:
Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is...
1
by: Jassim Rahma | last post by:
I have a form which has more than 10 combobox controls and all should be filled from a different fields in different tables in one mySQL database. I want to do this using the code and not at design...
2
by: jim | last post by:
I have created a Table that has 13 fields and 2 Primary Keys, e.g. 60 1, 60 2, ... 60 28, 61 1, 61 2, ... 61 28, etc... I want to create a Form where I can input the Primary Key values to query...
2
by: yadrdr | last post by:
I have an Employees tbl, and then a 2nd table needs to be populated. Half data is from Employee tble, other half data entry. I have a form that will populate the 2nd table. The ID combo box I...
1
by: keri | last post by:
I would like to have a combo box on a form that shows the results of a query, however the query is variable and i am unsure how to do this. I have NO knowledge of code so very basc instructions...
1
by: leedspaddy | last post by:
Hi there, I set the default value of a combo box on a form using the following code in the properties box: cboContactType.itemdata(0) and of course nothing happens. I just want the combo box to...
3
by: buddyr | last post by:
Hello, I have a store database already set up with alot of data in it. I have one table: table1 fields: partNumber, storeName,date,amount,description- ( some others) I have one form: form1 up to...
11
by: jgoodnight | last post by:
Hi, I have a form with three combo boxes: Area, Sub-Area, and Factor. I've set up the Sub-Area combo box to list only those areas that are part of the selected area. I've set up the Factor combo...
5
by: dantebothermy | last post by:
Hi all, I have a form with a subform. On the form is a combo box with three choices "current", "former" and "all". I'd like to use that combo box to set the data source for the subform based on...
10
by: BeaBea | last post by:
Hi All, I have been reading some of the threads in your forum and decided to join and post my question. Hopefully it won't be too lengthy. I have created an Unbound Form called paramform2. ...
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: 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:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.