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

Unhide Specific Fields on basis of Selection on combo

P: n/a
Hi,

I have a combo with a list of names. On the basis of a particular name
selected, I want a few hidden fields to become visible.

Like, when "James" is selected, show CheckBox1, CheckBox2, CheckBox3

Could someone please help with this?

Cheers!
Sunny

Nov 24 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
su**********@gmail.com wrote:
Hi,

I have a combo with a list of names. On the basis of a particular name
selected, I want a few hidden fields to become visible.

Like, when "James" is selected, show CheckBox1, CheckBox2, CheckBox3

Could someone please help with this?


In the AfterUpdate event of the ComboBox...

Me!CheckBox1.Visible = (Me!ComboBoxName = "James")
Me!CheckBox2.Visible = (Me!ComboBoxName = "James")
etc...

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 24 '05 #2

P: n/a
Thank you very much! one of the quickest responses ever!

Nov 24 '05 #3

P: n/a
Hi, I tried this but it doesnt seem to work...could you please advise
on the possible reasons

Nov 28 '05 #4

P: n/a
su**********@gmail.com wrote:
Hi, I tried this but it doesnt seem to work...could you please advise
on the possible reasons


Often a ComboBox contains one value while displaying another. The ComboBox
might not be equal to "James" when "James" is displayed. In that case you
have to test for the "real" value or reference a column besides the bound
one...

Me!CheckBox1.Visible = (Me!ComboBoxName.Column(n) = "James")

....where n is the zero-based ordinal position of the column you want to
reference.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 28 '05 #5

P: n/a
It works fine ! Thanks

Dec 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.