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

Grabbing displayed value of dropdown

bard777
P: 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.

Share this Question
Share on Google+
1 Reply


bard777
P: 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

Post your reply

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