473,401 Members | 2,127 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,401 software developers and data experts.

Grabbing displayed value of dropdown

bard777
23
I have a form that includes a dropdown getting it's values and display from a lookup table. The value is just the autonumber for the row and the display text is a name field. This works great for the overall functionality, but when I log an action I would like to write the display value to the log since the actual autonumber value would be useless.

Anyone know how to do this? Seems like I halfway remember doing something like:

me.list_box.value(1)

Thanks in advance for the help!
Apr 29 '10 #1

✓ answered by bard777

I must be asking questions too soon...thsi si the 2nd one I have answered for myself.

I needed to use Column, as in:

Me.lst_owner.Column(1)

This gives me the owners name vs. the autonumber associated with their record in the lookup table.

1 1726
bard777
23
I must be asking questions too soon...thsi si the 2nd one I have answered for myself.

I needed to use Column, as in:

Me.lst_owner.Column(1)

This gives me the owners name vs. the autonumber associated with their record in the lookup table.
Apr 29 '10 #2

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

Similar topics

2
by: Melissa | last post by:
Hi all, I am trying to retrieve data from a dropdown listbox in asp using: <%Response.Write + Request.Form("cboBox")%> The problem is that I only retrieve the first value of the option. For...
4
by: Lisa | last post by:
I know this is supposed to be easy but I can't get this to work. I have a dropdown that pulls all the Projects (tp_title) available. All I want to do is get the ID (tp_id) of that record so I can...
6
by: Amer Neely | last post by:
I have a page showing dynamic generation of a SELECT box using JavaScript. See http://www.softouch.on.ca/dynamic.html. Using Mozilla et al, choosing an option from both lists will result in the...
8
by: Lyn | last post by:
Hi, Can anyone tell me how the initial value displayed in Combo Box is determined when a form is opened? I am loading the dropdown from one field ("CategoryName") of a table, with "ORDER BY ". ...
1
by: Mad Scientist Jr | last post by:
I don't know how this is happening, but a dropdown control I have is resetting to the 2nd value on the list anytime a postback occurs. I have no initiation code outside of If Not (IsPostBack) ...
2
by: Mike Collins | last post by:
I cannot get the correct drop down list value from a drop down I have on my web form. I get the initial value that was loaded in the list. It was asked by someone else what the autopostback was...
3
by: Steve | last post by:
I have a databound dropdown in my page. I want to make one of the values the default value. Any ideas? Just to explain further, I have also appended one item to the dropdown, using the...
5
by: mantrid | last post by:
Hello Im trying to find the correct syntax to use to determine whether which form element is visible on changing the value in a dropdown list I need something in the onChange of the dropdown...
10
by: bootzwiz | last post by:
Hi, I have two dropdowns. In first dropdown i have two languages say english, persian. When i select english in 2nd dropdown iam able to show list of english movies. Problem is i need first...
3
by: John | last post by:
I have two dropdown lists that I have bound to a datatable and set the DataTextField and DataValueField for. Both lists show the values I expect from the database. However, when I need to access...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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...
0
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...

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.